Thread: Subtracting more than 24 hours from a Date/Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KSCGerald KSCGerald is offline
external usenet poster
  
Posts: 3
Default Subtracting more than 24 hours from a Date/Time
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)?
Reply With QuoteReply With Quote