Subtracting more than 24 hours from a Date/Time
Thanks Mama, that works!
"Teethless mama" wrote:
=A1-(70/24)
It should give you 1/7/08 08:20:44, not 1/8/08 08:20:44
"Teethless mama" wrote:
=A1-TIME(70,,)
"KSCGerald" wrote:
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)?
|