When you enter times, you can insert any separator sign that you want between the units, but it is not necessary.
You do not need to write minutes, seconds or AM/PM.
The following table lists the various ways in which times can be entered and how they are interpreted:
|
Entry |
Interpretation |
|
5 |
05:00:00 |
|
5:30 |
05:30:00 |
|
0530 |
05:30:00 |
|
5:30:5 |
05:30:05 |
|
053005 |
05:30:05 |
|
5:30:5,50 |
05:30:05.5 |
|
053005050 |
05:30:05.05 |
You must enter two digits for each unit of time if you do not enter a separator.