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

In article <78593490-9DF9-4A29-B950-BB6EC4EA1EE7@microsoft.com>,
"Sunny" <Sunny@discussions.microsoft.com> wrote:

> 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

[Niek Otten]

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"Sunny" <Sunny@discussions.microsoft.com> wrote in message
news:78593490-9DF9-4A29-B950-BB6EC4EA1EE7@microsoft.com...
> 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