Formula for adding time

[Doug AllPool]

Hello, I want to put in a start time in B2 and have B3, B4, B5, B6 be
filled in with a formula.
If I put 1:00 pm in B2 - B3 would add to 1:40 and so on.
A B
1 Location start time
2 stop 1
3 stop 2 B2 + 40 minutes
4 stop 3 B3 + 55 minutes
5 stop 4 B4 + 35 minutes
6 stop 5 B4 + 75 minutes
7
8 How long
9 25 minutes
10 30 minutes
11 45 minutes
12 50 minutes

13 75 minutes

Thank you, Doug

 

[nita]

Doug, select a cell to the side of your work area -- say E1. In it enter
0:01. Then you can create simple formulas for your cells: =B2+(E1*40) and
you will get your base time (1:00) plus 40 minutes. It will work with any
number of minutes -- I tested using =B2+(E1*120) and came up with 3:00.

 

[Fred Smith]

To add time values, use the Time function. So B3 would be:
=b2+time(0,40,0)
etc.

Regards,
Fred