•1 min read•from 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
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#Excel alternatives for data analysis
#real-time data collaboration
#real-time collaboration
#generative AI for data analysis
#big data management in spreadsheets
#AI-native spreadsheets
#google sheets
#predictive analytics in spreadsheets
#cloud-native spreadsheets
#AI formula generation techniques
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions