paul cooper-brunink
New Member
- Joined
- Jan 20, 2005
- Messages
- 4
Hi all,
I have to find a quick way to understand for how many minutes a machine was running. The start and stop times are manually recorded on a time sheet. I need to make this electronic to give a quicker data analysis than is currently used. The time sheet has the date for the start of the shift, along with many others items (down time reasons & time, scrap qtys & reasons/time etc). The time sheet continues over the 24 hour period, covered by 3 shifts. (6am-2pm, 2pm-10pm & 10pm-6am).
As the machine is started and stopped frequently throughout a 24 hour period, i need to find the total time in mins, the machine was running for over the 3 x 480 min shifts. And assume that unless logged otherwise, the remainder is downtime. Also needed in minutes.
ie,
Machine No 1 Shift starts on 19-1-05 06:00
Mc stopped at 07:37
Mc started at 10:41
Mc stopped at 05:46 on 20-1-05
Down time logged as 07:37 to 09:21
What was the total time the mc was running? (Mins)
What was the total down time? (Mins)
What was mc running time for shift 1, 2 & 3?
What was total down time for each shift?
I will have the data arranged in columns. (Or differently if it helps)
Can any body suggest a formula, and the correct formatting for Excel 2000 that will give the desired results?
I cannot seem to get it to work so far...
PS, Yes I admit it, I'm an engineer!
Thanks for any help in advance.
Paul.
I have to find a quick way to understand for how many minutes a machine was running. The start and stop times are manually recorded on a time sheet. I need to make this electronic to give a quicker data analysis than is currently used. The time sheet has the date for the start of the shift, along with many others items (down time reasons & time, scrap qtys & reasons/time etc). The time sheet continues over the 24 hour period, covered by 3 shifts. (6am-2pm, 2pm-10pm & 10pm-6am).
As the machine is started and stopped frequently throughout a 24 hour period, i need to find the total time in mins, the machine was running for over the 3 x 480 min shifts. And assume that unless logged otherwise, the remainder is downtime. Also needed in minutes.
ie,
Machine No 1 Shift starts on 19-1-05 06:00
Mc stopped at 07:37
Mc started at 10:41
Mc stopped at 05:46 on 20-1-05
Down time logged as 07:37 to 09:21
What was the total time the mc was running? (Mins)
What was the total down time? (Mins)
What was mc running time for shift 1, 2 & 3?
What was total down time for each shift?
I will have the data arranged in columns. (Or differently if it helps)
Can any body suggest a formula, and the correct formatting for Excel 2000 that will give the desired results?
I cannot seem to get it to work so far...
PS, Yes I admit it, I'm an engineer!
Thanks for any help in advance.
Paul.