I am formatting a string like so:

.Column("StartTime").Value = Format(clsDateConvert.sShortTime, "hh:mm:ss AMPM")

This works perfectly most of the time, but if the sShortTime value is 24:00, it will not format the value correctly.

i.e.
for "23:00" it will convert to "11:30 PM" properly
but for "24:00" it will remain as "24:00" instead of converting to "12:00 PM"

Why does this happen?