When you need to add up hours in excel, you will find that it ignores the hours greater 24:00, one reason I found because of the “Time” format. To workaround this, I found two ways of doing it.
1. If you change the “Total” cell format to “custom” with [h]:mm
2. If you change the “Total” cell format to “number”, and then multiply the total by 24
This is usually helpful when you need to do timesheet at work, especially the accountant usually deal with the labour hourly rate.