Calculate time (excluding weekend (48 hrs))
=NETWORKDAYS(C3,C4)*24
"AndyO_UK" wrote:
Need help to calculate the total number of hours excluding the 48 hrs of a
weekend.
Currently my spreadsheet looks like this:
C3 (date/time) start
D3 (date/time) end
E3 number value total hours (=(D3-C3)*24)
Grateful for any help.
|