•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