Time Calculation
 

:confused: 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..........


--
chintu49
------------------------------------------------------------------------
chintu49's Profile: http://www.excelforum.com/member.php...o&userid=18631
View this thread: http://www.excelforum.com/showthread...hreadid=345844

=MOD(A2-A1,1)

--

HTH

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


"chintu49" wrote in message
...

:confused: 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..........


--
chintu49
------------------------------------------------------------------------
chintu49's Profile:
http://www.excelforum.com/member.php...o&userid=18631
View this thread: http://www.excelforum.com/showthread...hreadid=345844

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(B1A1,B1-A1,1+B1-A1)

The 1 efectively adds 24hrs onto the time

hope this is what you need

RES


--
RES
------------------------------------------------------------------------
RES's Profile: http://www.excelforum.com/member.php...o&userid=19307
View this thread: http://www.excelforum.com/showthread...hreadid=345844