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