Formula For Time Duration Calculation

[Deen]

Hi Every One,

I Have excel sheet like,
A B
C
REPORTEDDATETIME STATUSDATE Result
(HH:MM)
02/16/2009 04:00 AM 02/16/2010 04:00 AM 8760:00
02/16/2010 04:00 AM 05/16/2010 07:00 PM 672:00
03/20/2010 02:00 AM 03/21/2010 02:00 AM 24:00

I required Result like that column C, Could you please any one can help me
on this.

 

[teylyn]

Hi,

simply subtract like

=B1-A1

and format the result with custom format

[hh]:mm

regards, teylyn

 

[FSt1]

hi
see your other post
regards
FSt1