Hi,


I am new to excel and i was wondering the ways to find out the difference between two date/time but it should exclude weekends.


A1
04/03/16 10:00

A2
07/03/16 10:15

The two cells A1/A2 have been formatted to record DD/MM/YY HH:MM (inputted manually).
The answer A2-A1= 3 days, 0hrs 15mins however, I want Excel to automatically exclude the weekend so that the real answer is 1 day, 0hrs 15mins.

I know a little about the NETWORKDAY / INTL functions but they did not work correctly.
Now I know there are ways to add optional holidays, but because the optional holidays occur rarely, I want to keep it really simple and basic and perhaps add another function to record those odd bank holidays.

Please help!

What do you expect to be returned if the time in A2 is for example 20:00 (or should I say 8:00 pm?) if such value can occur.