2 dates difference, NETWORKDAYS, custom working hours.

[yupo72]

Hi all,
I have to calculate the real hours duration of tickets raised by Helpdesk comparing them with their Priority (E4, R1, R3, R5).
In some way I've always do this mixing formulas and manual checks, but I'd like to use the correct final solution.
My difficult has always been the NETWORKDAYS because it cut off the whole Saturday but Helpdesk works on Saturday morning.

Considering that Helpdesk works Mon-Fri 07:00-22:00 and Sat 07:00-14:00, how can I calculate the effective time in hours between open and close date/time?
Format of dates should be dd/mm/yyyy hh:mm (european format).

Could anyone please help me?
Thanks in advance

[daddylonglegs]

Can the open/close date/times be outside the helpdesk hours? Do you also have holiday dates to exclude?

[yupo72]

Can the open/close date/times be outside the helpdesk hours? Do you also have holiday dates to exclude?

Yes, it is possible to raise tickets outside helpdesk hours and yes, holidays have to be excluded.
Thanks

[Kevin UK]

Hi yupo72

If you have Excel 2010 you can use the NETWORKDAYS.INTL and third argument as below is Mon-Sat = "0000001" or Mon-Thu = "0000111", Tue-Sat = "1000001" etc

Please Login or Register  to view this content.

[yupo72]

@Kevin UK,

Thanks, nice info.
But this take Sat as a whole working day, isn't it?


Administrative Note:

• As per Forum Rule #12, please limit quotes to only that which is necessary -- otherwise it's just clutter...Thanks.