Elapsed time with custom work week.

[JH]

I have a huge problem. I need to determine elapsed time in hours for
projects. The main problem I am having is that I do not know how to
set up a custom work week of 6am Monday - 6pm Friday.

I have a formula now, but it does not take into account the special
hours on Monday and Friday, but it does exclude the weekends.

=NETWORKDAYS(Y2,Z2)-1+IF(NETWORKDAYS(Z2,Z2),MOD(Z2,1),1)-
IF(NETWORKDAYS(Y2,Y2),MOD(Y2,1),0)

Where:
Y2 = DATE IN
Z2 = DATE OUT

Is there anyway to establish
Mon - 6a-11:59p
Tues - 12:00a - 11:59p
Wed - 12:00a - 11:59p
Thurs - 12:00a - 11:59p
Fri - 12:00a - 6:00p

Any help would be very appreciated

Jonah

 

[Jays]

Just minus the times from each other - as a baseline, using [h]:mm as number
format (date)