Time Calculation

[chintu49]

HI Experts,

well, i was wondering if there is any formula for the time to calculate
the subtraction between two time intervals, becoz in some case i get
incorrect value!!!

Now say A1 has time 23:04 P.M and A2 has time 7:56 A.M, so if we do
subtraction by using calculator then ideally as per the time norms in
24 hours it should give me 8.52 Hours, where in if i do simple
subtraction then it gives me error. similarly any values in A1 and A2
should give me appropriate difference...i m sorry if i sound very
immature, but i m novice.....thnx

chintu..........

 

[Bob Phillips]

=MOD(A2-A1,1)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[RES]

because excel doesn't know you mean 7:56 the next day you are
effectively asking it to show a negative time.
Therefore you have two options
firstly enter both a date and time
or use an "if" formula

=if(B1>A1,B1-A1,1+B1-A1)

The 1 efectively adds 24hrs onto the time

hope this is what you need

RES