AmPm$

Takes one parameter, Source

Description:

This function converts 24-hour time formats to standardized 12-hour AM/PM format and normalizes existing AM/PM time inputs. It handles various input formats, including standalone times, date+time combinations, and malformed AM/PM designations. However, it does not validate the date and time values.

Format Rules:

Hour Digit Formatting

AM/PM Standardization

Date Preservation

Examples:

24-Hour Time Conversion

Html ("AmPm$ ""00:00:00"": " & (AmPm$ "00:00:00"))  ' AmPm$ "00:00:00": 12:00:00 AM
Html ("AmPm$ ""01:00:00"": " & (AmPm$ "01:00:00"))  ' AmPm$ "01:00:00": 1:00:00 AM
Html ("AmPm$ ""12:00:00"": " & (AmPm$ "12:00:00"))  ' AmPm$ "12:00:00": 12:00:00 PM
Html ("AmPm$ ""13:00:00"": " & (AmPm$ "13:00:00"))  ' AmPm$ "13:00:00": 1:00:00 PM
Html ("AmPm$ ""23:59:59"": " & (AmPm$ "23:59:59"))  ' AmPm$ "23:59:59": 11:59:59 PM
Html ("AmPm$   ""9:15"": "   & (AmPm$   "9:15"))    ' AmPm$   "9:15": 9:15 AM

 

AM/PM Format Normalization

Html ("AmPm$ ""10:30 AM"": " & (AmPm$ "10:30 AM"))  ' AmPm$ "10:30 AM": 10:30 AM
Html ("AmPm$ ""10:30AM"": "  & (AmPm$ "10:30AM"))   ' AmPm$ "10:30AM": 10:30 AM
Html ("AmPm$ ""10:30pm"": "  & (AmPm$ "10:30pm"))   ' AmPm$ "10:30pm": 10:30 PM
Html ("AmPm$ ""10:30A"": "   & (AmPm$ "10:30A"))    ' AmPm$ "10:30A": 10:30 AM
Html ("AmPm$ ""10:30P"": "   & (AmPm$ "10:30P"))    ' AmPm$ "10:30P": 10:30 PM

 

Date + Time Combinations (Single-Digit Hours)

Html ("AmPm$ ""2025-01-15 00:00:00"": " & (AmPm$ "2025-01-15 00:00:00"))  ' AmPm$ "2025-01-15 00:00:00": 2025-01-15 12:00:00 AM
Html ("AmPm$ ""2025-01-15 09:30:00"": " & (AmPm$ "2025-01-15 09:30:00"))  ' AmPm$ "2025-01-15 09:30:00": 2025-01-15 9:30:00 AM
Html ("AmPm$ ""2025-01-15 13:30:00"": " & (AmPm$ "2025-01-15 13:30:00"))  ' AmPm$ "2025-01-15 13:30:00": 2025-01-15 1:30:00 PM
Html ("AmPm$ ""2025-01-15 23:59:59"": " & (AmPm$ "2025-01-15 23:59:59"))  ' AmPm$ "2025-01-15 23:59:59": 2025-01-15 11:59:59 PM

 

Date + Time Combinations (Double-Digit Hours for ISO Format)

Html ("AmPm$ ""2025-01-15T00:00:00"": " & (AmPm$ "2025-01-15T00:00:00"))  ' AmPm$ "2025-01-15T00:00:00": 2025-01-15T12:00:00 AM
Html ("AmPm$ ""2025-01-15T09:30:00"": " & (AmPm$ "2025-01-15T09:30:00"))  ' AmPm$ "2025-01-15T09:30:00": 2025-01-15T09:30:00 AM
Html ("AmPm$ ""2025-01-15T13:30:00"": " & (AmPm$ "2025-01-15T13:30:00"))  ' AmPm$ "2025-01-15T13:30:00": 2025-01-15T01:30:00 PM
Html ("AmPm$ ""2025-01-15T23:59:59"": " & (AmPm$ "2025-01-15T23:59:59"))  ' AmPm$ "2025-01-15T23:59:59": 2025-01-15T11:59:59 PM

 

AM/PM with Dates

Html ("AmPm$ ""2025-01-15 10:30 AM"": " & (AmPm$ "2025-01-15 10:30 AM"))  ' AmPm$ "2025-01-15 10:30 AM": 2025-01-15 10:30 AM
Html ("AmPm$ ""2025-01-15 10:30pm"": "  & (AmPm$ "2025-01-15 10:30pm"))   ' AmPm$ "2025-01-15 10:30pm": 2025-01-15 10:30 PM
Html ("AmPm$ ""2025-01-15T10:30 PM"": " & (AmPm$ "2025-01-15T10:30 PM"))  ' AmPm$ "2025-01-15T10:30 PM": 2025-01-15T10:30 PM
Html ("AmPm$ ""2025-01-15T10:30A"": "   & (AmPm$ "2025-01-15T10:30A"))    ' AmPm$ "2025-01-15T10:30A": 2025-01-15T10:30 AM