Extract first and last time of daily sales

**sans** · 09-09-2012, 09:35 AM

Hello,

I have a list of sales by day/date and would like to extract the first and last time of the daily sales as in the attachment. I have tried using a formula but I haven't managed to get to the desired results.

Thank you for looking

**Special-K** · 09-09-2012, 10:10 AM

Your spreadsheet is a bit of a mess
Your dates and times in column A and B are text (they have leading spaces)
But your dates in H6:K6 are numbers

Use the attached file

**sans** · 09-09-2012, 10:24 AM

Yes, it was a bit of a mess

Thanks!

**sans** · 09-10-2012, 01:24 AM

The formula works great but I have just encountered a slight problem. Usually, sales usually start at noon/afternoon and continue up to 11:00 pm at night. Sometimes though, a day's sales might start at i.e. 15:00 at noon and where the last sale might take place a few hours after midnight i.e. at 01:00am the following day. For example,

First Sale:
9/9/2012
15:00 pm

Last Sale:
01:00 am
(10/9/2012)

Would it be possible in this case for the formula to return the 01:00am time as the last sale of day 9/9/2012, even though the sale was actually made on the 10/9/2012?

Thank you