Subtracting Dates and Times

[Guest]

Hi

I have two columns of data which are in dd/mm hh:mm format (the date and
time are important). I need to know the number of days between the two
figures (eg 1.65 days) - a simple subtraction works fine ... BUT ... weekends
get in the way and I want to eliminate weekends from the calculations.

Eg Date/time 1 = 08 Oct 13:00h
Date/Time 2 = 11 Oct 13.00h

The result should be 1.0 days and not 3.0 days.

It was suggested that I use Networkdays or Workdays but it doesn't seem to
take into account the times.

Any other suggestions?

Thanks in advance!!

 

[Frank Kabel]

Hi
use NETWORKDAYS