A1: start date/time
B1: End date/time

=(NETWORKDAYS(A1,A2,holidays)-1+MOD(A2,1)-MOD(A1,1))*24

Format cell as General


"Paula D" wrote:

I'm running a report to show the turn-around times for a task, but want to
exclude weekends and holidays. For instance if an employee began working on
a task on Friday, March 9th 2007 4:00 pm (column a) and completed it on
Tuesday, March 13th, 2007 4:00 pm (column b), I want to calculate in column c
what the true turn-around time (date/time difference) was, excluding the
Saturday and Sunday in between since these weren't work days and shouldn't
count against that employee. The turnaround time should calculate to 48
hours but because the weekend is in there, it shows as 96 hours. Any ideas?
Thank you!