SOLVED

Calculate Stop times

Brass Contributor

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

5 Replies

@Todd Lane 

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

HansVogelaar_0-1681473107603.png

Or even easier:

HansVogelaar_1-1681473207991.png

Thanks @HansVogelaar,

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

 

ToddLane_0-1681475864430.png

 

best response confirmed by Todd Lane (Brass Contributor)
Solution

@Todd Lane 

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.

Thanks so much @HansVogelaar

@Todd Lane 

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)

image.png

1 best response

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

@Todd Lane 

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.

View solution in original post