Vacation Tracking formula

[Rehab brain]

I am trying get my formula for hours accured in a vacation tracker
spreadsheet to show up as 60 minutes in an hour instead of 100 minutes.

=(D8/(52/$J$12)*D10 results are 1.85 hours, I want it to read 2.25 hours

Cell D8 = 48 hours
Cell $J$12 = 1 weeks per pay period
Cell D10 = 1 accured every # of periods

Same thing is this formula =OFFSET(J18,-1,0,1,1)+D18-G18 where the current
results are 50.81 hours and should show as 51.21 hours.

 

[Fred Smith]

The result *is* 1.85 hours. It's not 1 hour and 85 minutes, as I'm assuming
you're thinking when you want it converted to 2.25 (which would be better
displayed as 2:25).

If you want it displayed as h:mm, then divide by 24, and format as h:mm. But
the result will be 1:51, not 2:25.

Regards,
Fred