calculate hours

[Sunny]

How can i count hours between this two days in excel?
a1 2/8/2007 10:00 b1 2/9/2007 23:10
the sum should be 37 hours 10 min

 

[JE McGimpsey]

One way:

=B1-A1

Format the cell with Format/Cells/Number/Custom [h]:mm

 

[Niek Otten]

=B1-A1, then format Custom as [h]:mm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel