Forum Discussion
Pandaboom
Feb 27, 2023Copper Contributor
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...
- Feb 27, 2023
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.
HansVogelaar
Feb 27, 2023MVP
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.
Pandaboom
Feb 27, 2023Copper Contributor
I applied your recommendation too and it fixed it. Thank you so much! THE RELIEF! lol