Is there a way to input military time in the time field without having to use colons (:)? As of now I have to write 16:00 to get 4:00 PM in the time field but I would like to input it like this: 1600 and output should be 4:00 PM it would save a lot of time when inputting thank you.
not tested but you could try
var text DataEntry = totext([my new data entry field]);
ToTimeOfDay(NotRight($DataEntry, 2) & ":" & Right($DataEntry, 2))
If you have existing data using the old method you will need to have a formula field to use that old field if it was populated else the new field.
I also have a formula which allows users to enter just the time of day, such as 200 for 2:00 pm. In an app I wrote for a client they are only open during normal business hours, so I can infer the AM PM based on the value entered, ie 200 must be 2:00 PM and 1000 must be 10:00 AM.
Attack at 0600 and be back to barracks by 1600!Military Time Shortcode - Add New Record
The script will recognize four consecutive digits as a military time and convert it to civilian format. This is just a demo created in a few minutes so if you enter 9999 you will get 87:99 PM - duh?