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.

"Ltat42a" wrote in
message ...

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


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile:
http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=567617