I have a basic "time in" and "time out" timesheet where I enter the times that I come and go. It has the following formula below.
In a different cell (N2), I have Total Hours shown. N2 cell is formatted as "Time" (not Number, nor General).
=(D2-C2)+(G2-F2)+(J2-I2)+(M2-L2)
My problem - if I have 6AM in cell C2 and 12:45PM in cell D2, the "Total Hours" cell (N2) shows as 6:45. I want it to show 6.75 hours.
Any way to change the formula to get the Total Hours to round to the nearest 0.25 and show 6.75 hours?
Thanks!
Bookmarks