Excel not accumulating time field correct

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.

Leave a Reply

Your email address will not be published. Required fields are marked *