Hi,
Glad I found this forum.
I need help!
Am trying to write a formula that will give the time taken to complete a task, excluding weekends & holidays.
Below is the format of the start and end dates for the tickets:
Start Date
1/21/2014 5:50:00 PM
End Date
1/22/2014 10:20:00 AM
Work week: Sunday to Thursday
I've tried the NETWORKDAYS.INT formula but the result 2days 00hrs:00mins. Also if the start and end date is on the same day it calulates as 1 day instead of the total hours.
Any help is much appreciated.
Thanks,
Dia
Bookmarks