Changing Time To 0.75 Instead of 0.45

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!

Try

=((D2-C2)+(G2-F2)+(J2-I2)+(M2-L2))*24

Format cell as number instead of time

Yep - that worked for me. Thank you!

You're welcome.