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 … Continue reading Excel not accumulating time field correct