Dec 19 2018 10:59 AM
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 format though.
Example O5 is 10:30, P5 is 17:00, Q5 is 6:30, I want Q5 to read as 6.5 hrs so I can keep total of hours for the job at the end of these columns.
Dec 19 2018 02:55 PM
Instead of your formula you may use
=(P5-O5)*24
and apply General or Number format
Feb 09 2021 05:56 AM
@Sergei Baklan Thanks, this worked for me.