I am keeping track of time in column ‘C’. All of the entries and the column itself is formatted in the proper time style. The formula entered is =MAX (C2:C32) and the given answer is incorrect. The answer given is 9:00, yet there are several entrys greater than that.
Date Day Time
Nov 01 Sun 08:00
Nov 02 Mon 08:45
Nov 03 Tue 08:00
Nov 04 Wed 09:15
Nov 05 Thu 03:45
Nov 06 Fri 05:15
Nov 07 Sat 10:15
Nov 08 Sun 07:30
Nov 09 Mon 08:15
Nov 10 Tue 08:00
Nov 11 Wed 04:30
Nov 12 Thu 08:55
Nov 13 Fri 08:00
Nov 14 Sat 07:30
Nov 15 Sun 09:30
Nov 16 Mon 09:00
Nov 17 Tue 09:00
Nov 18 Wed
Nov 19 Thu
Nov 20 Fri
Nov 21 Sat
Nov 22 Sun
Nov 23 Mon
Nov 24 Tue
Nov 25 Wed
Nov 26 Thu
Nov 27 Fri
Nov 28 Sat
Nov 29 Sun
Nov 30 Mon
Averages 09:15
Maximum 09:00
Minimum 03:45
(Edited for clarity by @Lupp; Try to give short, but significant examples, please.)