Calulating Time Difference from separate Date and Time fields

[bsrivatsa]

Hi,
I have two sets of date and time columns and need to calculate the time difference between them. My attempts are resulting in erroneous answers. Please see the attached file and help me with the value in cell L3 (shaded yellow)

Thanks.

B. Srivatsa

[curiouscat408]

First, the formula for your "concatenated" cells (H3, K3) should be (H3 for example):

=F3 + G3

formatted as you wish. In my case: Custom m/d/yyyy h:mm .

Note that F3 and G3 are numeric, not text.

Second, without relying on H3 and K3, the time difference in L3 can be:

=F3-I3 + G3-J3

formatted as Custom [h]:mm . The squared bracketed [h] displays hours greater than 23.

Caveat: With that format, the time difference must not be negative.

PS.... If you want decimal hours in L3, the formula would be =(F3-I3 + G3-J3)*24 formatted as General or Number. In that case, the time difference can be negative.

[bsrivatsa]

Thank you for the quick solution.