Microsoft Excel 12 Working with Dates and Times

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Working with Dates and Times in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00So in Microsoft Excel, you can go ahead and display out date and time in multiple formats.

00:11For example, I'm going to go around over here and type in, let's say, for example, 12122026

00:19right here, for example. So you can see that this is a numbered format date right here. So this is

00:24a date, as you can see. Apart from that, you can also go ahead and select short date, which is

00:29actually the format right now, or you can choose long date right here and it gets converted into a

00:35long date format. Apart from that, you can also go around onto more number formats right here,

00:40just like this. And over here, you can see the date. And then these are the different date formats that

00:46you can go ahead and add in. For example, over here, you can see that there's March 1412 right here.

00:53So you can see like this is how it would be displayed right here. You can go around over here

00:58onto more number formats and choose a particular format right here, press OK, and it'll be converted

01:04to that particular format as well. Let's say, for instance, I'm going to go ahead and type in

01:091 p.m. right here. So this is a time right here, just like this. So now what you can do is you can

01:16see that this is a custom time. You can go for the normal time format that you have right here,

01:21or what you can also do is go to more formats right here. Then it goes to time. And here you can see

01:27that I can go ahead and choose date and time as well if I want to right here, just like this.

01:32So you can enter date and time right here. So I'm just going to go around over here and type in

01:372026 right here, just like that. And I'm just going to go ahead and type in 1212. Let's say,

01:44for instance, then this is the format that you have. So let's just go around over here onto more

01:48formats. Then I'm going to go to time. And you can even go ahead and choose this time format or

01:53any other time format as you want. And then you simply have this. You still have the date

01:58information right here. So if you were to change the format, it will show up the date as well.

02:03But right now you can see that I only chose time. So you can only see the time right here.

02:10And that is how you can simply go ahead and add in dates and times inside of Excel and choose the

02:16format of display for it as well. So hope you found this video useful. Be sure to hit the like

02:23button. Don't forget to share this out with your friends and family. And for more contents like

02:28these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended