Subtracting more than 24 hours from a Date/Time
Thanks David, that works!
"David Biddulph" wrote:
=A2-B2/24, if your original date and time are in A2 and your 70 in B2.
--
David Biddulph
"KSCGerald" wrote in message
...
I am working on a schedule and I need to subtract 70 hours from the event
time. If the event time is 1/10/08 06:20:44, when I subtract 70 hours, it
only subtracts 22 hours with the TIME function, hence calculating 1/9/08
08:20:44. Is there some way to get Excel to automatically subtract the 70
hours to get the actual date and time (1/08/08 08:20:44)?
|