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.
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.
Format Custom as [h]:mm
--
Kind regards,
Niek Otten
"leo" <[email protected]> wrote in message news:[email protected]...
> 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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks