Vacation Tracking formula
 

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.

Vacation Tracking formula
 

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

"Rehab brain" <Rehab wrote in message
...
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.

Vacation Tracking formula
 

You need to explain what the contents of the cells are. What does 48
represent in D8? What is "1 weeks per pay period" in J12? What is accrued in
D10?
What are the contents of the cells in row 18?

Please be specific.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Rehab brain" wrote:

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.