1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Timesheet Calculator Not Correctly Giving Total

I am trying to build a timesheet calculator and the outcome is not working with my formula. I want to use decimal for the time so I created the AM PM columns. I was trying to get the Break column to calculate with the same format as the start and end time, but that wasn't working, so I will just use minutes for Break.

Below is the spreadsheet. I do not understand why the time is giving me a negative total and your help is appreciated. Thanks

https://docs.google.com/spreadsheets/d/1yxIwpekmawfFBgkBBgxstFbVOur3p3O_hFIGKOB2qA8/edit?usp=sharing

submitted by /u/GlideAndGiggle
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article