Custom Number Formats - Date and Time | Google Sheets Tutorial 16
In this lesson, We are going to explore:
0:00 Getting started.
0:23 How to show the whole name of the day, month, and full numeric year?
0:44 How to show the abbreviation name of the day, month, and two-digit year?
1:20 What symbols are used to separate the date and time?
1:50 How to show the 12-hour clock?
2:05 The Custom date and time formats window.
All explanations are simple and to the point.
#GoogleForEducation #GoogleWorkspace #GoogleSheets
If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded
Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor):
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
The whole playlist link:
• How to Use Google Sheets - Detailed T...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
Sound from Zapsplat.com
Apple logo
https://iconscout.com/contributors/pi...
Windows logo
https://pixabay.com/it/users/
Welcome back, Educators.
We’re going to explore all about the custom date and time formats.
Here we have the same date and time but with different formats.
To start, click Custom number format on the Format menu.
If we like to show the whole name of the day, month, and full numeric year,
We type 4d for the day, 4m for the month, and 4y for the year.
If we like to show the abbreviation name of the day, month, and two-digit year,
We type 3d for the day, 3m for the month, and 2y for the year.
If we like to show the day and month with leading zero,
We type 2d for the day, 2m for the month.
We could use the forward-slash or the hyphen symbol as a date separator.
We could use the colon or the dot as a time separator.
We could insert emojis into the date and time format.
We’ve used the CHAR formula to create these emojis.
To show the 12-hour clock, type am/pm.
With a single h placeholder, the leading zero doesn’t appear.
We could edit the preset formats to fit the need.
The data in the cell with a custom format is number, and we could use the formulas to make the calculations.
Try to format the day and month without the leading zero,
The year with two-digit,
And the time with just hours and minutes.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.
