ExcelBanter - Adding hours and minutes

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Adding hours and minutes (https://www.excelbanter.com/excel-programming/358328-adding-hours-minutes.html)

leo

Adding hours and minutes

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

Adding hours and minutes

Format Custom as [h]:mm

--
Kind regards,

Niek Otten

"leo" wrote in message ...
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

Adding hours and minutes

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" wrote in message
...
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.

All times are GMT +1. The time now is 05:41 PM.