Working days and hours calculation - request assistance please!

S

sbickley

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.
 
P

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
 
S

sbickley

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif between Time stamps and have - value 0
How to calculate difference between two date & time along with working hours and days 2
how do I calculate a week days hours with the 24hour clock 5
Calculation completion date/time 6
Help with a formmula change in a "flag" parameter! 19
Getting and error while calculate business hours between 2 dates with holidays. 4
Formula to Compute Overtime hours 1
Date + X days excluding holidays 1

Top