Hi, I need help sorting times when part of them are before midnight.
We have a spreadsheet where shift supervisors enter parts made and the time periods those parts were ran along with other information which isn't relative to this issue.
I need to sort the rows of data for each shift based on the time that each part was started.
This works fine on 2 of the shifts, but night shift crosses over midnight and I'm having a hard time sorting.
Night shift runs from 11:00 pm till 7:00 am.
example:
Part 1 was started at 11:00 pm
Part 2 was started at 11:30 pm
Part 3 was started at 1:00 am
Part 4 was started at 2:00 am
and so on.
When I hit sort, even if they may have been entered into the spreadsheet in different orders than listed above, I need the resulting rows to be listed in order by time from 11:00pm till 7:00am.
When the shift supervisors enter their start times in the time column, they do not enter the date. Just the time.
I hope that was enough info.
Thanks
We have a spreadsheet where shift supervisors enter parts made and the time periods those parts were ran along with other information which isn't relative to this issue.
I need to sort the rows of data for each shift based on the time that each part was started.
This works fine on 2 of the shifts, but night shift crosses over midnight and I'm having a hard time sorting.
Night shift runs from 11:00 pm till 7:00 am.
example:
Part 1 was started at 11:00 pm
Part 2 was started at 11:30 pm
Part 3 was started at 1:00 am
Part 4 was started at 2:00 am
and so on.
When I hit sort, even if they may have been entered into the spreadsheet in different orders than listed above, I need the resulting rows to be listed in order by time from 11:00pm till 7:00am.
When the shift supervisors enter their start times in the time column, they do not enter the date. Just the time.
I hope that was enough info.
Thanks