timings query

[stevehorton]

Hi i have a start and end date/time.

What i want is for it to miss out the weekends and formulate how muc
time it took between the start and finish time.

Below i have copied a few lines in.

Submitted Approved
09 July 2004 09:54:24 12 July 2004 04:06:18
09 July 2004 11:56:59 12 July 2004 03:42:34


So basically add from 9:54 in the morning till midnight (preferably 5p
but dont think it would be possible), then miss the 10th and 11th an
add the 4:06.

I know its possible but am a little lost!

any help welcom

 

[Frank Stone]

I had a similar problem. I solved in by creating a table
call shop calander then used the lookup function to get
the time. the table eliminate weekend and holidays. its in
an excel file to big to put here. email me at
(e-mail address removed) and i'll send it to you.