Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vacation Tracking | Excel Worksheet Functions | |||
creating beginning vacation use and tracking it | Excel Discussion (Misc queries) | |||
Vacation Tracking Template | Excel Discussion (Misc queries) | |||
vacation tracking in excel | Setting up and Configuration of Excel | |||
vacation tracking calendar on exel sheet for 2006 | Excel Discussion (Misc queries) |