Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difference between Date & Time for workdays
Is there a way to calculate the difference between two dates only counting
working days, but also including the difference in times? I am familiar with the NetWorkDays formula, however, I need to find the difference between the specific times. Ex. We are trying to calculate the time it takes in days, hours, minutes, for someone to perform a task. But we want do not want to count the weekend days. So if someone starts a task on Friday at 8 am & finishes the following Mon at 3 pm, can you create a formula for that? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference in needed and delivered time with workdays only | Excel Worksheet Functions | |||
date and time difference | Excel Worksheet Functions | |||
Difference in date and time | Excel Discussion (Misc queries) | |||
Date and time difference | Excel Worksheet Functions | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) |