u/GlideAndGiggle

Timesheet Calculator Not Correctly Giving Total
▲ 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