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.

 

[FSt1]

hi
in c1 enter...
=b1-a1
format c1 as
[h]:mm

also on your second example...
from 02/16/2010 04:00 AM to 05/16/2010 07:00 PM is 89.625 days.
time 24 hours per day is 2151 hours. did i miss something?

regards
FSt1