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.
I have only looked at the first part of your post but, there, the problem appears to be that the total of hours given by
= SUM(finish - start)is 1.08333 which means 1 and ¹⁄₁₂ days. Formatted as time this shows only the 2 hours. The number format to use is "[h]:mm" which will show the result in the form "26:00"
- I applied your recommendation and it fixed it. Thank you so much! THE RELIEF! lol
