Forum Discussion
MarkShnier__You
Qrew Legend
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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
MikeTamoush
2 years agoQrew Commander
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
------------------------------
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
------------------------------