View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rehab brain Rehab brain is offline
external usenet poster
 
Posts: 1
Default 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.