Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
can someone help me with a formula it is not giving me the right times. The
formula is supposed to figured the time between dates. It is not giving me the right times. sometimes its high and sometimes its lower than what it should be. I hope someone can help me i need this for keeping track of my employees and questions please contact me. The formula is =IF(G2="","",(((NETWORKDAYS(F2,G2,$W$2:$W$22)-1)/3+MOD(G2,1)-MOD(F2,1)+((MOD(G2,1)<0.5)-(MOD(F2,1)<0.5))/48)/E2)) I can email you the sheet I am talking about it you would like. I can't attach my sheet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula not working properly | Excel Worksheet Functions | |||
vlookup not working properly | Excel Discussion (Misc queries) | |||
Filter Not Working Properly | Excel Worksheet Functions | |||
average(if not working properly | Excel Worksheet Functions | |||
But not working properly | Excel Discussion (Misc queries) |