View Single Post
 
Old 09-18-2014, 02:32 PM
talon1driver talon1driver is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Sep 2014
Posts: 2
talon1driver is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote