12/24H HH:MM user’s preferred format leading zero only 24H

Hi

I have some comments of users that would like to have the 24H time with a leading zero and the 12H time without.

I found this formula which allows user to select but sets the 12H time with leading zero which I don’t want.

$#Db#>9?#Db#:0(#Db#)$:#DmZ#

So I need User selectable 12H/24H and just leading Zero for 24H time ?

Many thanks if you can help.

You will find the easy way is to use the #Db# tag for the 12-hour time and the #DHZ# tag for the 24-hour time and use opacity to filter between the two.

3 Likes