Subtracting more than 24 hours from a Date/Time

  • Thread starter Thread starter KSCGerald
  • Start date Start date
K

KSCGerald

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)?
 
Isn't that what the OP had already done? Doesn't that suffer from the fact
that it wraps round at 24 hours, hence the OP's comment about 70 hours being
treated as 22 hours, i.e. =MOD(70,24)?
Hence the need to use =A1-70/24
 
Back
Top