furmula to add hours
Good stuff. thanks!
"Roger Govier" wrote:
Hi
Try
=B3+TIME(23,59,59)
Since time is stored as fractions of a day, you could also use
=B3+3.5/24 to add 3 hours 30 minutes to the value in B3
--
Regards
Roger Govier
"Stephen" wrote in message
...
I have a cell (B3) that is a date formatted as 01/01/08 0:00:00
I want a formula in another cell (D3) that takes the value of B3 and adds
time to it.
eg.
B3 - 01/01/08 00:00:00
D3 - 01/01/08 23:59:59
??
|