SOLVED

Calculate Stop times

Brass Contributor

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.

Todd

5 Replies

Re: Calculate Stop times

For example (result to the left, formulas to the right):

Or even easier:

Re: Calculate Stop times

Thanks

Im not getting same results. Would you mind sharing what format you are using on each cell

best response confirmed by Todd Lane (Brass Contributor)
Solution

Re: Calculate Stop times

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.

Re: Calculate Stop times

Thanks so much @HansVogelaar

Re: Calculate Stop times

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)``````

1 best response

Accepted Solutions
best response confirmed by Todd Lane (Brass Contributor)
Solution

Re: Calculate Stop times

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.