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?
