Forum Discussion
Solved
Assistance with Excel Calculation Issues
Hello. I'm hoping to get some help on this problem I'm having, I cannot for the life of me understand why my spreadsheet is not calculating simple attraction using the =SUM() or =. I have tried g...
Apply the custom number format [h]:mm to the cells that sum times.
The square brackets [ ] around h instruct Excel to display the total as cumulative time (that can be more than 24 hours) instead of as clock time.
Also, if the start time could be before midnight and the end time after midnight (for example someone worked from 8:00 PM to 4:00 AM), change the formula =D5-C5 to =MOD(D5-C5, 1)
I applied your recommendation and it made it better by applying this formula to allow for the before midnight and after, cause many of the employees do work these hours =MOD(D5-C5, 1)
- Thank you so much! I really appreciate this extra bit of advise.
- Thank you so much! I really appreciate this extra bit of advise.