Chris

I was not entering time in correctly in first two columns but now it does
not add up the two times.
Scott

"scott45" wrote:

I want to calculate the number of hours that our water plant operates. During
the course of a day we may start up and shut down a couple of times. I have
made two columns one for start time and one for shut down.I also have a
column that has the time so the operators then enter in the start time next
to this column. Any suggestions would help how to calculate plant hours-this
is running time. This case would be 9 hours of actual run time

Time Start Sut Down
0000
0100
0200 2:00
0300
0400
0500
0600 6:30
0700
0800
0900
1000 10:00
1100
1200
1300
1400
1500 3:00