View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deen Deen is offline
external usenet poster
 
Posts: 22
Default Formula For Time Duration Calculation

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.