Working days and hours calculation - request assistance please!

[Guest]

OK, I am thouroughly confused and need some help. I am trying to compute the
difference in working hours between when an object starts on the line to when
it leaves the line, accounting for an 8 hour workday and excluding holidays
and weekends, although some saturdays are spent working. Example:

Start: 8/10/06 7:00 AM Leave: 8/15/06 10:00 AM

Exclude weekend (Sat/Sun) and assume a 8 hour workday. How many total work
hours were expended? Is there a simple way to subtract the date/time periods
and then convert the days and hours to account for the 8 hour workday.

 

[Pete_UK]

What are your working hours? On the first day you will need to account
for the number of hours remaining in the shift after the start time,
and on the final day the number of hours from the beginning of the
shift until the leave time.

Pete

 

[Guest]

Let's say the working hours are 7 AM to 3:30 PM. Can you demonstrate how
this would work?