Forum Discussion
How to change hours worked on a project from 24 hr time to a decimal hr?
This is what I have: Cell O5 is clock in time, cell P5 is clock out time. They are both formatted military time, cell Q5 is total hours with simple formula =P5-O5 I want this to not be in time forma...
Instead of your formula you may use
=(P5-O5)*24
and apply General or Number format
SergeiBaklan Thanks, this worked for me.
