Formula help...

  • Thread starter Thread starter BB
  • Start date Start date
B

BB

I need help in devising a formula that will subtract 100 hours from a
specific date and time. For example, if I entered a date and time (1/20/04
@ 1140) I would like the formula to subtract the 100 hours and give me that
date and time (1/16/04 @ 0740). Is that possible?
 
If you enter your date and time as a real date and real time:

01/20/2004 11:40:00
You can just subtract the 100 hours (100/24 represents 100 hour)

=a1-(100/24)

and format as mm/dd/yyyy hh:mm:ss
(or your favorite date/time format)

1 = 1 day = 24 hours. So 100/24 is really 4.167 days (or 100 hours).
 
BB,

Sure.
=A2-100/24

Or if the 100 hours is a variable, put it in B2 (100:00:00, or 100:00) and
use

=A2-B2

Format for date/time as desired (Format - Cells - Number - Date or Time).
 
Back
Top