To apply the Format function, we need to select the cell that contains the date-time value and then type a comma after it. After that, we should type "Format" and then press Enter on our keyboard. The screen will show us two options - General and Custom.
Select the cells you want to format.
Press CTRL+1.
In the Format Cells box, click the Number tab.
In the Category list, click Date.
Under Type, pick a date format.
If you want to use a date format according to how another language displays dates, choose
the language in Locale (location).
The following is a list of shortcuts for formatting date-time in MS Excel:
Ctrl + Shift + R - Format cells as date.
Ctrl + Shift + D - Format cells as time.
Ctrl + Shift + T - Format cells as time with am/pm.
Ctrl + Shift + H - Format cells as 24 hour clock.
Ctrl+Shift+ A – Apply the same formatting to all cells in the selection.
You can use the Preview tab to see how your changes will look before you apply them to your document. You’ll also be able to see how the formatting will change for each paragraph, including lists and headings. Previewing formatting changes before applying them is a great way to make sure that you are not wasting time on formatting that will not be used.
As previously stated, the excel time format code is hh:mm:ss. Let me now go over this code in detail. hh: This time code is a double-digit figure that reflects the hour component of the time. For example, in the preceding example, our time value was 06; however, if you merely say "h," the hour part will only be 6, not 06.
Learner's Ratings
4.7
Overall Rating
82%
10%
5%
3%
0%
Reviews
S
Sathi Nanda
5
Very good teaching quality
S
Soibol Debnath
5
It a very good course.
S
syed enterprise
5
thank you dear
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.