ExcelBanter - Formula For Time Duration Calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula For Time Duration Calculation (https://www.excelbanter.com/excel-discussion-misc-queries/259458-formula-time-duration-calculation.html)

Deen

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.

FSt1

Formula For Time Duration Calculation

hi
see your other post
regards
FSt1

"Deen" wrote:

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.

All times are GMT +1. The time now is 08:38 AM.