00:00So now let's see how we can go ahead and format out date and time in Excel. Let's say for example,
00:11I'm going to go around and say 12 p.m. right here, then it actually knows that it's a time,
00:16and you can see that Excel displays it out like this. But if you want to go ahead and change the
00:22format of the time, you can actually go around over here and choose time right here just like
00:27this, and then you get this format. But if you want to change around the format totally, then you can
00:32go around over here onto more number format as this is selected. And over here, you can see that
00:37time is option. Here you can go ahead and select out the time format as you wish right here just
00:42like this. And you can even go ahead and as per the location right here, you can see that you get the
00:48time option. So let's say for example, I'm going to go around over here, press OK, then you get that
00:53particular time format. Go to more number format right here, go around over here, then you get
00:58that particular time format right here. Similarly for the date as well. So let's say for example,
01:03I'm going to say 12-12-2026 right here, just like this. Right here, this is a date. I can go around
01:10over here, change it into a short date, which is currently the format, but I can go ahead and change
01:15it to a long date as well, where you actually see the day, you see the month, date, and the year. You can go
01:22around over here onto more number format as well. And here you can see that you get the date option
01:27where you can go ahead and select out different formats as you wish as well. So if I were to go
01:32around over here onto more number formats, you can see that I can select this one as well. If I were to
01:37go around over here onto more number format, you can even see the date with time as well. So if I were to
01:43go around and press OK right here, just like this, then you can actually see that this is the time and you
01:49can go ahead and enter up the time data as you want, just like this as well, along with the date
01:54right here. But if I were to go ahead and change to long date format, the time data is still there,
02:00but since we chose only the date format, it only displays out the date. So that is how you can go
02:06ahead and format out date and time as you like to display it out in different formats as you like
02:12inside of Microsoft Excel. So I hope you found this video useful. Be sure to hit the like button.
02:19Don't forget to share this out with your friends and family.
02:22And for more contents like these, do follow simple tutorials.
