Register now or log in to join your professional community.
It is just by Clicking at CNTRL and 1 at same time and inserting the time (12:00:00 AM/PM)
1. Change the Hours per week value to 84.
2. Change the Hours per day value to 12.
3. Change the Default start time value to 12:00 AM and the Default end time value to 18:00 PM
4. Change the Days per month to 30.
5. Press the OK button, when the above changes have been completed.
CTRL+1 and then use 12:00 format
choose File > Options > Date Format and select the format of the date
or use ctrl+1
Thank you for your question.
You can use the number format by using Ctrl+1 to show Cell Format dialog box.
Then, use the below format:
hh:mm:ss am/pm
Regards