I am working on an Excel spreadsheet in Excel 2007 that shows sleep study results. One of my columns shows the times the patient went to bed each night and they range from 9:00 pm to 2:00 am I need to calculate the Average time in bed, the Min time they went to bed, and the Max time they went to bed. The problem is that Excel is looking at this as a 24 hour clock with 11:59 pm being the latest time and 12:00 am being the earliest. I need it to look at 2:00 am as being later than 9:00 pm. Does anyone know of a way to do this? Basically if Excel would look at the time range as 12:00 pm being the earliest and 11:59 am being the latest it would calculate correctly, but I have not been able to figure out how to do this. Any suggestions would be greatly appreciated.