View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Narowski[_2_] Chris Narowski[_2_] is offline
external usenet poster
 
Posts: 4
Default Difference between date & time calculation

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