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
--
David Biddulph

"Teethless mama" wrote in message
...
=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)?