soundchaser99
New Member
- Joined
- Mar 30, 2006
- Messages
- 16
This one has me stumped
I need to track the total time taken to complete a job in hours. The problem is the job may take several days and I only want to count actual work hours.
I've tried using DATEDIF function and looked through some of the archives but so far no luck
BAsically, a user enters the following:
Start date (A1), Start Time (B1), End Date (A3), End Time (B3).
The work day is 9hr long - from 6.30am to 4.30pm. (1hr lunch - not to be included)
So, for example if they started a job at 8am on the 10th, and finished at 2pm on the 12th the total work time should equal 23 hours, broken down as follows:
10th 8am-4.30pm = 8.5hr - lunch = 7.5hr
11th 6.30am - 4.30pm = 10hr - lunch = 9hr
12th 6.30am - 2pm = 7.5hr - lunch = 6.5hr
7.5+9.0+6.5 = 23hrs
Any ideas?
I need to track the total time taken to complete a job in hours. The problem is the job may take several days and I only want to count actual work hours.
I've tried using DATEDIF function and looked through some of the archives but so far no luck
BAsically, a user enters the following:
Start date (A1), Start Time (B1), End Date (A3), End Time (B3).
The work day is 9hr long - from 6.30am to 4.30pm. (1hr lunch - not to be included)
So, for example if they started a job at 8am on the 10th, and finished at 2pm on the 12th the total work time should equal 23 hours, broken down as follows:
10th 8am-4.30pm = 8.5hr - lunch = 7.5hr
11th 6.30am - 4.30pm = 10hr - lunch = 9hr
12th 6.30am - 2pm = 7.5hr - lunch = 6.5hr
7.5+9.0+6.5 = 23hrs
Any ideas?