•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why is my hrs. Worked showing negative number?
I making a spreadsheet to help track overtime
I have one column labeled DATE formatted as a date mm/dd/yyyy Then I have a TIME START and a TIME END COLLUMN
I am using formula =(A2-A1)*24
For example
Date 2/10/2026
Start time : 10:00 PM TIME END : 3:00AM HRS WORKED: -19
How do I make it so excel knows the 3AM is from 2/11/2026
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#real-time data collaboration
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#hrs worked
#Excel
#spreadsheet
#DATE