Posted by Jason on November 27, 2000 6:02 AM
I have a spreadsheet that the night warehouse uses to record when they finish pulling an invoice. The manager would like to know when the last invoice was finished. The warehouse works from 8:00pm to about 4:00am. When sorting the spreadsheet it treats the times as military time therefore the last time they worked (around 4:00am) is in the middle of the sort. Is there a way to create a formula that will look at the list and let us know what the last time in the morning was used. Thanks.