That wasn't your original question... you asked how to calculate working hours between two dates.
I don't know if there's any easy or clean way to do it when your hours are spread over two days since they cross the midnight threshold (others might be able to come up with one), see below for links on how you'd do it if the working hours are on the same day. You could have to write a bunch of if statements which align with the logic you want to apply, something along the lines of:
If it's a non-Monday weekday and the hour is 3am or lower, get the time (e.g. 2.5 hours if it's 2:30 am). If it's 6pm or later, get the time and subtract 15 (since 3am to 6pm aren't working hours)
If it's a Saturday and the hour is 3am or lower, get the time (we're still on shift from Friday).
If it's a Monday and the hour is 3am or lower, do nothing (work doesn't start until 6pm). If it's after 6pm, get the hour and subtract 18 (since work starts 6pm Monday and there was no midnight-3am work).
You can get the hour component by using frac(datetime)*24, and you can still use networkdays() to get the number of days between your two dates, so you just need the if() statements to address the hours component.
For other ideas, you can look at:
https://community.qlik.com/t5/QlikView-Documents/Working-Hours-Calculation-excluding-weekends-and-ho...
https://community.qlik.com/t5/QlikView-App-Dev/Networkdays-Calculation-Exact-Decimals-Required/td-p/...
I'm not sure if this will help with your specific requirement owing to the cross-midnight issue, but otherwise it's the same requirement so hopefully it'll help.
