Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Home -> Number -> Format Cells Subtract the Start from the End. An appointment that goes from 9 AM to 5 PM is an 8 hour day. You can format the numbers to make the math easier. For example, 5:00 PM would be 17:00 hours in military time.   Now, the equation would be: =EndTime - StartTime, or =17:00 PM -  9:00 AM, or =8 hours duration Try it: Sample Calendar Data 1. Select Column C, Start Time.   2. Format the Column for Time Go to Home -> Number ->Format Cells.