Working days and hours calculation - request assistance please!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sbickley - 16 Aug 2006 18:37 GMT

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.

Reply to this Message

Pete_UK - 16 Aug 2006 19:15 GMT

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

> 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
[quoted text clipped - 6 lines]
> 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.

Reply to this Message

sbickley - 16 Aug 2006 19:39 GMT

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

> 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,
[quoted text clipped - 13 lines]
> > 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.

Reply to this Message