Nevermind. I just did it. Here it is if anyone needs it. It lost the formatting and i dont have tie to go back and indent everything so it is pretty, but it should work.
var text Orig = ToText([24 Hour Time]);
var text AMPM = Right($Orig," ");
var text Prefix = Left($Orig,":");
var text Suffix = Left(Right($Orig,":")," ");
var text NewPrefix =
If($AMPM = "pm",
If(
$Prefix = "01","13",
$Prefix = "02","14",
$Prefix = "03","15",
$Prefix = "04","16",
$Prefix = "05","17",
$Prefix = "06","18",
$Prefix = "07","19",
$Prefix = "08","20",
$Prefix = "09","21",
$Prefix = "10","22",
$Prefix = "11","23",
$Prefix = "12","12"
),
$AMPM = "am",
If(
$Prefix = "12","00"
),
$Prefix
);
$NewPrefix & ":" & $Suffix
------------------------------
Mike Tamoush
------------------------------
Original Message:
Sent: 09-12-2019 08:10
From: Mark Shnier (Your Quickbase Coach)
Subject: Preserve 24-Hour Time Format in Formulae
I think that you will need to come up with your own text formula to preserve the 24 hour format.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
Original Message:
Sent: 09-11-2019 15:26
From: Benjamin Golden
Subject: Preserve 24-Hour Time Format in Formulae
I have a Formula-Text field that has a Time field inserted into it. The field itself is set to display a 24-hour format, but when put into the formula via the ToText() function, I get the standard format. So the way I see it, I have two options:
1. Write a subformula like Right("00" & Hour([T]), 2) & ":" & Right("00" & Minute([T]), 2)
or 2. Use a function that's not listed to preserve the format. Is there one available, or should I just go with writing out the function?
------------------------------
Benjamin Golden
------------------------------