|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Timesheets - id'ing two people working on the same machine at the same time.
Hi,
I have a long list of timesheets. Each timesheet is on a row and I have about 2,000 of them. Each timesheet shows: - start time - end time - operator - machine - other non-relevant info with each piece of info in a separate column. Sometimes only 1 operator will be on a machine, and sometimes 2 or 3 operators will be on the same machine. Sometimes operators 2 and 3 will start after operator 1, and finish before operator 1, or even finish after operator 1. I am trying to find the sum of all hours that a machine works in the day, irrespective of the number of operators on it. So if op 1 starts at 6am, and op 2 starts at 7.30am, but then they both work on that machine until 10am, then I want to have 4 hours as the output. If, however, op 2 keeps going on that machine until 10.30am, then the output should be 4.5 hours. Any ideas of the best way of doing this? I can't work out how to work out how much time is duplicated if another operator clocks on. Many thanks, Will |
#2
|
||||
|
||||
Could you please post a small sample sheet showing some data and expected reults? Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
infopath for timesheets & project management | eekoh | Misc | 0 | 02-24-2015 07:57 AM |
Moving OneNote files from Win 7 machine to a new Win 8.1 Pro machine - how to do it successfully? | WesternGuy | OneNote | 7 | 01-03-2015 02:48 PM |
Powerpoint to be edited by Multiple People | nikkiliz10 | PowerPoint | 0 | 07-12-2013 08:37 AM |
Send emails to multiple people at once | marreco | Excel Programming | 2 | 05-13-2012 06:38 PM |
unable to open .RTF files in server machine from client machine | Naresh_1210 | Word | 0 | 03-12-2010 03:26 AM |