Skip to main content
W
wendyb399
Participant
June 14, 2016
Answered

I want to enter the time, but I want the colon to automatically appear so I dont have to type it in all the time

  • June 14, 2016
  • 1 reply
  • 1998 views

I want to enter a time in a field, but I want the system to automatically put in the colon.  Example:  I enter 830 and the system enters 8:30

This topic has been closed for replies.
Correct answer try67

The mask I provided should work. You need to enter it without the quotes, of course...

1 reply

try67
Community Expert
try67Community Expert
Community Expert
June 14, 2016

Under Format, select Special, Arbitrary Mask and then enter "99:99". It will add the colon automatically when you enter the time, but you'll always have to enter four digits. Also, it won't validate that what you enter is a valid time (ie, you could enter "98:76")...

W
wendyb399Author
Participant
June 14, 2016

Actually, this did not work.  I did some more digging.  Under format, Arbitrary Mask, enter 99:\99.

You must always enter 4 digits.  Therefore 0830 shows as 08:30.

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
June 14, 2016

The mask I provided should work. You need to enter it without the quotes, of course...

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices