
▲ 1 r/excel
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
u/GlideAndGiggle — 7 days ago