Prev: Nees Function to Split
Next: Icon Sets - Display icon in one cell depending upon value in anoth
From: Doug AllPool on 25 Feb 2010 16:08
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


From: nita on 25 Feb 2010 17:18
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.

"Doug AllPool" wrote:

> 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
>
>
> .
>
From: Fred Smith on 25 Feb 2010 20:13
To add time values, use the Time function. So B3 would be:
=b2+time(0,40,0)
etc.

Regards,
Fred

"nita" <nita(a)discussions.microsoft.com> wrote in message
news:A742849A-F58F-42B2-AFAE-829DC1A84D7C(a)microsoft.com...
> 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.
>
> "Doug AllPool" wrote:
>
>> 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
>>
>>
>> .
>>

 | 
Pages: 1
Prev: Nees Function to Split
Next: Icon Sets - Display icon in one cell depending upon value in anoth