I have a formula to convert a time field to text. It works for all times except 12:00 - 12:59.
Depending on AM or PM values in the 12:00 hour either show up like "0:00" for AM or "12:0" for PM.
Here is the formula:
TEXT(HOUR(Show_Time__c))&":"& TEXT(MINUTE( Show_Time__c ))
Any advice on how I can make the values between 12:00 and 12:59 format as HH:MM?
3 answers
I would write it like this
IF(
OR(
HOUR( Time_1__c ) = 0,
HOUR( Time_1__c ) = 12
),
'12',
TEXT(
IF(
HOUR( Time_1__c ) > 12,
HOUR( Time_1__c ) - 12,
HOUR( Time_1__c )
))) +
MID( TEXT( Time_1__c ), 3, 3) +
IF(
HOUR( Time_1__c ) < 12, ' AM',
' PM')
