G
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!!
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!!