Increment formula for time

[Ltat42a]

Can a formula be used to increment times in a cell?

A2 = 08/02/2006 2:00pm
A3 = same date + 3 hrs (5pm)
A4 = same date + 3 hrs (8pm)
A5 = same date + 3 hrs (11pm)
A6 = 08/03/2006 2:00am
etc
etc
etc


Thanx

 

[Guest]

Hi

Excel stores one day as 1. So three hours is 1/8 - as 3 hours is one eigth
of a day. To increment by three hours, simply add 0.125

Hope this helps.
Andy.

 

[VBA Noob]

Enter this into A2 and drag down

=A2+ TIME(3,0,0

 

[oldchippy]

Can a formula be used to increment times in a cell?

A2 = 08/02/2006 2:00pm
A3 = same date + 3 hrs (5pm)
A4 = same date + 3 hrs (8pm)
A5 = same date + 3 hrs (11pm)
A6 = 08/03/2006 2:00am
etc
etc
etc


Thanx

Hi Ltat42a,

Try something like this

Enter date in A2 in 24hour format

08/02/2006 14:00

In cell B1 type 3:00 (represents 3 hours and will automatically forma
to time)

In A3 type formula

=A2 + $B$1

Copy this down, date will increment by 3 hours

oldchippy :

 

[Ltat42a]

Thanx everyone, all 3 examples worked fine.

...Ltat42