Adding hours and minutes

[leo]

I'm trying to create an Overtime sheet for work hours. However, If I work 16
hours 1 day and 9 the next, this totals to 01:00 instead of 25:00. I'm losing
money... please help me.

[Niek Otten]

Format Custom as [h]:mm

--
Kind regards,

Niek Otten

"leo" <leo@discussions.microsoft.com> wrote in message news:01C7FC0F-5A56-4BAD-8FD0-51E70FB0ACB3@microsoft.com...
> I'm trying to create an Overtime sheet for work hours. However, If I work 16
> hours 1 day and 9 the next, this totals to 01:00 instead of 25:00. I'm losing
> money... please help me.

[Chip Pearson]

Use a custom number format of

[hh]:mm

The [] characters tell Excel not to "roll over" time at 24 hours.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"leo" <leo@discussions.microsoft.com> wrote in message
news:01C7FC0F-5A56-4BAD-8FD0-51E70FB0ACB3@microsoft.com...
> I'm trying to create an Overtime sheet for work hours. However,
> If I work 16
> hours 1 day and 9 the next, this totals to 01:00 instead of
> 25:00. I'm losing
> money... please help me.