Thread: Date/Time Formula for Entry level XL user
View Single Post
 
Old 09-18-2014, 02:58 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote