Help please ???????

[jonnymenthol]

Hello All,

First of all, apologies if this is an embarrisingly simple query, but I hope someone out there can help me.

I'l try to break it down.

I have 5 stages to a process. At each stage I would like to log the date and time that the process was logged. I.e
Stage 1 => 31/10/01 => 09:00
Stage 2 => 31/10/01 => 16:00
Stage 3 => 01/11/01 => 10:00
etc, etc.....

But, what I'd then like to do is have a seperate box automatically calculate for each stage, with the number of working hours between in it (I work 9 - 5). So in the above example it would be :
Stage 1 => 31/10/01 => 09:00
Stage 2 => 31/10/01 => 16:00 => 7 Hours
Stage 3 => 01/11/01 => 10:00 => 2 Hours

Obviously I'd also want to exclude weekends (therefore if Stage 1 was logged at 16:00 on Friday Afternoon and Stage 2 was logged at 16:00 on Monday Afternoon, I'd want this to show as 8 Hours.

Can anyone out there help me please ?????

I apologise in advance If this is not very clear, but I can be e-mailed to clarify if needs be.

Any advice at all would be appreciated.

Many Thanks

Jonny