Hello, everyone, and this lecture, we will be covering date and time related functions in Excel,
we all maintain different time in different formats.
Sometimes we use Daid Montagnier, which is driven by way, or sometimes it is mandated immediately
by way of sometimes Demand-Driven in words instead of No.
ICSOM supports all this war mentality, even identified the important, if those are deeds or not.
For example, if I take one OK and press enter.
It picks up that it is dead automatically and any formula, but it is written in the poll date format.
One function which we will use to see today's date in default for matters is equal to today function.
This just returns to today's date whenever the is of this formula is also refreshed.
So this is showing no right now.
But if I lose the heat and open it tomorrow, it will show that in November, similar is the function.
Retail is equal to now.
And you can see this includes the time also along with the date.
Important thing to note here is, although actually showing us the time in readable format in the back,
it maintains dates and times in no format.
If it change the to number four, we can see that it is converted to remember the endangered part of
this number is actually the count of days from first and nineteen hundred.
So four plus Jan 19 under Disvalue will be one for December nineteen hundred.
This value will be 365.
Today is world number 2018, which is forty three thousand four hundred fifteen days from what, nineteen
hundred?
The decimal part denotes the time, so 24 hours will be one unit.
For 12 hours, it will be 12 to 24 and one is equal 2.5.
For six hours, it will be six by 24, which is point to five right now, it is for at 32 p.m., which
is 16 hours, 32 minutes, which is coming out to be point six nine.
Now, we will see some common daytime formats available in Excel or this date.
If we want it in some other format, right, click on the Cell and Select for mental.
In the category menu, we can select day to look at different date formats, we can select time in the
category menu to look at different time formats.
We can also create a custom format, go to type, click on custom, go to type, feel and maintain the
format for debate related format if we want complete munt a m.
Four year Bayway.
And then time as it's Colin and then.
Into the.
We can see that the daytime value is now shown in the desired format.
Next, we look at the mundane, yet formless.
For any particular date, we can separate different parts of it using these formulas, so to get which
day of the month it is a day and to liquidate.
Today's world, they have no so.
The solution?
With the kind of month in any year use is equal to one selected it.
November is the right one.
So you are getting liminality.
So to get your ear unselected.
Are getting 2013 in this.
Important operations that we usually need to do on and values involve finding the number of days between
two dates or finding time difference between two time timestamps to find the number of days between
two dates you can use is equal to days and to this date.
This returns the number of days between the two dates.
We can see that between 12 member and first number, there is a difference of 11 days.
Similarly for the next case, there is a difference of four hundred forty days.
You can also do this by simply separating the two dates.
You can see it is giving us the same result, you can figure out why this well, by recalling that date
and Excel captain, no farmer and the friends of those numbers and in the number of days they are apart.
To get this different in us, multiply this value the 24.
To get it in a minute, but then multiply it with 60.
Third way to find difference in the due date is the data function.
This function allows you to specify what you want in return, whether you want the days, months or
years, four days we tape is equal to the different.
Stardate.
And the.
Gonna be four days and four months and by four years.
So you can see that in the second row.
There is a difference of 15 months.
Between the two they selected.
Similarly, it can be done for getting the difference is.
That's all for this lecture in the next lecture, you will discuss the index match and look functions.
Thanks.