Time Formats
(:) | Time seperator. This seperates hours, minutes and seconds when time values are formatted |
ttttt | Displays the time as a complete time (second, minute & hour) formatted to a ???. The default for Windows is "h:mm:ss" |
yyyy | Displays the year as a 4-digit number (100 - 1999) |
h | Displays the hour as a number without a leasing zero (0 - 23) |
hh | Displays the hour as a number with a leading zero (00 - 23) |
n | Displays the minute as a number without a leading zero (0 - 59) |
nn | Displays the minute as a number with a leading zero (00 - 59) |
s | Displays the second as a number without a leading zero (0 - 59) |
ss | Displays the second as a number with a leading zero (00 - 59) |
AM/PM | Use the 12 Hour clock and display in uppercase |
am/pm | Use the 12 Hour clock and display in lowercase |
A/P | Use the 12 Hour clock and display in uppercase |
a/p | Use the 12 Hour clock and display in lowercase |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext