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(), 2) & ":" & Right("00" & Minute(), 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
------------------------------
