This is my first post so bare with me...

I need to calculate business hours between two dates that includes Satursday...Can anyone help out...I've tried looking for old threads but havent managed to find anything....


Constants:
Work Days = Monday to Friday
Work Hrs = 07:00 to 19:00

Work Day = Satuday
Work Hrs = 07:00 to 14:00

Format:
Start date DD/MM/YYYY HH:MM:SS
End date DD/MM/YY HH:MM:SS


I have the following formula with counts weekday criteria only

=(NETWORKDAYS('Start date','end date')*('End work time'-'Start work time')+MEDIAN(MOD('end date',1),'End work time','Start work time')-MEDIAN(1*MOD('start date',1),'End work time','Start work time')

Start work time is 07:00
end work time is 19:00

Any suggestion how to take into account weekends?