Z
ziggyg
Problem- Have a business that is open 24/7, we get jobs that can start
during any shift and continue from either 1 hr to a couple of days.
What I need to do is to figure out how much time is spent on each job
per shift. First shift is from 7:30 to 15:30, second from 15:30 to
23:30, and third from 23:30 to 7:30. I have three columns, first would
be "start date and time, second would be "Finish date and time" both
columns would be formated to "mm/dd/yy hh:mm:ss" with a third column
with total time. if a job starts at, say, 09/15/03 13:30:00, and ends
at 09/17/03 04:30:00, how do I find the total time each shift worked on
that job, not just total job time?
during any shift and continue from either 1 hr to a couple of days.
What I need to do is to figure out how much time is spent on each job
per shift. First shift is from 7:30 to 15:30, second from 15:30 to
23:30, and third from 23:30 to 7:30. I have three columns, first would
be "start date and time, second would be "Finish date and time" both
columns would be formated to "mm/dd/yy hh:mm:ss" with a third column
with total time. if a job starts at, say, 09/15/03 13:30:00, and ends
at 09/17/03 04:30:00, how do I find the total time each shift worked on
that job, not just total job time?