Subtracting more than 24 hours from a Date/Time

[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)?

 

[Teethless mama]

=A1-TIME(70,,)

 

[David Biddulph]

=A2-B2/24, if your original date and time are in A2 and your 70 in B2.

 

[Teethless mama]

=A1-(70/24)

It should give you 1/7/08 08:20:44, not 1/8/08 08:20:44

 

[David Biddulph]

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

 

[KSCGerald]

Thanks David, that works!

=A2-B2/24, if your original date and time are in A2 and your 70 in B2.

 

[KSCGerald]

Thanks Mama, that works!

=A1-(70/24)

It should give you 1/7/08 08:20:44, not 1/8/08 08:20:44