Can TimePattern use the HH:MM:SS format?

I’ve not been able to find the ‘allowed’ or permitted possible time patterns and attempting to use the ‘HH:MM:SS’ format is not giving me the leading zero.

Unlike the datepattern( function, timepattern( makes no distinction between upper and lower case. MM and mm will both give you two digit minutes, SS and ss will both give you two digit seconds. HH and hh will both give you one or two digits as needed, with no leading zero. You are just going to have to use ("0"+timepattern(time,"hh:mm:ss"))[-8,-1] if you need that leading zero.

I just posted a note that makes one tiny correction. The formula Dave provides is correct, but there is a difference between HH and hh in the time pattern: for single digit hours, HH will pad the time with a space, and the formula would not always be correct if you used HH in the pattern instead of hh for single digit hours.

This question is about Panorama 6. Your observation is true for Panorama X, and also news to me. It is not true for Panorama 6.

A post was merged into an existing topic: TimePattern quirk, perhaps