Hi Mike

Thanks for your reply, Is working great




"Mike H" wrote:

Deen

Use the formula

=B2-A2

Format the formula cell with a Custom format of [h]:mm

Drag down
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Deen" wrote:

Hi Team,
A B
C
REPORTEDDATETIME STATUSDATE Result (HH:MM)
03/16/2009 07:00 AM 03/16/2010 07:00 AM 8760:00
02/16/2010 04:00 AM 02/16/2010 07:00 PM 15:00

See herewith i required the result like need to calculate time duration B-A,
Any one can help me on this.

Thanks in advance
Ahamed