Forum Discussion
Solved
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) ...
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.
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)