Forum Discussion
Calculate Stop times
Hi,
Think bus timetable.
I have a cell with formatted as a Time cell. Currently showing 8:00am
I also have a column formatted as hh:mm which shows a series of durations
2:13 (2 hours 13 mins)
1:07 (1 hour 7 mins)
1:01 (1 hour 1 minute)
Result I am looking for in the column next to duration column above would be time
10:13am (ie 8:00am + 2 hours 13 mins)
11:20am (ie 10:13am + 1 hour 7 mins)
12:21pm (ie 11:20am + 1 hour 1 minute)
Trying to work out how to achieve this.
Thanks in advance
Todd
The duration cells are formatted as hh:mm, and the start and stop times as h:mm AM/PM.
I have attached a sample workbook.
5 Replies
Excuse me for posting a 365 solution but the presentation can be very different using 365.
Worksheet formula = SCAN(Start, Duration, Sumλ) where Sumλ is = LAMBDA(x, y, x+y)Thanks HansVogelaar,
Im not getting same results. Would you mind sharing what format you are using on each cellThe duration cells are formatted as hh:mm, and the start and stop times as h:mm AM/PM.
I have attached a sample workbook.
