How to convert two dates in to HH:MM:SS

[sashaikh]

Hi,

I am trying to calculates the two dates cells diffrence int
hour:minutes:seconds. could some help me in finding a solution i
Excel sheet.

eg. Cell A1 = Jan-01-2004 00:00 Cell B1 = Jan-02-2004 23:30

Cell C1 = 47:30 looking for a result like 47 hours 3
min.

thanks

sa

 

[JE McGimpsey]

One way:

C1: =B1-A1

Format C1 with Format/Cells/Number/Custom [h]:mm