| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining work hours between dates / hours
I am currently using the following formula to calculate work hours. As it
happens on the time of measurement not all requests are finalised and I am getting a #NUM! calculation. This have an impact on my total calculations. How can I eliminate #NUM! =IF(AND(INT(O94)=INT(V94),NOT(ISNA(MATCH(INT(O94), List!A$9:A$24,0)))),0,ABS(IF(INT(O94)=INT(V94),ROU ND(24*(V94-O94),2), (24*(X94-W94)* (MAX(NETWORKDAYS(O94+1,V94-1,List!A$9:A$24),0)+ INT(24*(((V94-INT(V94))- (A94-INT(O94)))+(X94-W94))/(24*(X94-W94))))+ MOD(ROUND(((24*(V94-INT(V94)))-24*W94)+ (24*X94-(24*(O94-INT(O94)))),2), ROUND((24*(X94-W94)),2)))))) -- Andrew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WORK HOURS DIFFERENCE BETWEEN TWO DATES | Excel Worksheet Functions | |||
| UDF To Calculate Work hours between two dates Problem with code | Excel Discussion (Misc queries) | |||
| wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Calculate work hours between two dates | Excel Worksheet Functions | |||
Threaded Mode
