If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|