Quote:
Originally Posted by macropod
Simply input the date & time in the reference cell (say, A1), then use a formula like:
=A1-60/24
in the destination cell.
FWIW, days are integer values. Each hour, therefore, is 1/24 of a day. 1 second is 1/86400 of a day!
|
Thanks Paul. Worked like a champ! Thread can be closed.