Working days and hours calculation - request assistance please!

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

sbickley wrote:
> 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.

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

"Pete_UK" wrote:

> 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
>
> sbickley wrote:
> > 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.
>
>