Rehab Brains
New Member
- Joined
- Feb 26, 2010
- Messages
- 1
I am trying get my formula for hours accured in a vacation tracker spreadsheet as if it are 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.
=(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.