Formula for Hour Difference

Sameer_Kuppanath_Sultan 

There are several methods but since you are using 24 Hrs Date Time stamp value the I would like to suggest few, shown below.

1. Formula in cell Q26: 

=Q24-Q23

• Apply [h]:mm:ss cell format on the cell.
• [h] or [H] considers 24 hrs clock.

    2. Formula in cell Q28:

=TEXT(Q24-Q23,"[H]:MM")

    3. Now the formula which counts Days along with elapsed Hours, Minutes & Seconds in cell Q30.

=INT(Q24-Q23) & " days, " & HOUR(Q24-Q23) & " hours, " & MINUTE(Q24-Q23) & " minutes and " & SECOND(Q24-Q23) & " seconds"

   4. One more tricky formula is:

=IF(Q24>Q23,Q24-Q23,1-Q23+Q24)

• Applied cell Format is [h]:mm:ss .
• Adjust cell references in the formula as needed.