1
00:00:06,680 --> 00:00:11,150
Hello, everyone, and this lecture, we will be covering date and time related functions in Excel,

2
00:00:12,260 --> 00:00:14,440
we all maintain different time in different formats.

3
00:00:14,450 --> 00:00:21,410
Sometimes we use Daid Montagnier, which is driven by way, or sometimes it is mandated immediately

4
00:00:21,410 --> 00:00:25,010
by way of sometimes Demand-Driven in words instead of No.

5
00:00:26,190 --> 00:00:31,470
ICSOM supports all this war mentality, even identified the important, if those are deeds or not.

6
00:00:32,190 --> 00:00:36,120
For example, if I take one OK and press enter.

7
00:00:38,560 --> 00:00:45,570
It picks up that it is dead automatically and any formula, but it is written in the poll date format.

8
00:00:47,090 --> 00:00:53,960
One function which we will use to see today's date in default for matters is equal to today function.

9
00:00:55,690 --> 00:01:01,660
This just returns to today's date whenever the is of this formula is also refreshed.

10
00:01:02,140 --> 00:01:04,570
So this is showing no right now.

11
00:01:04,660 --> 00:01:10,420
But if I lose the heat and open it tomorrow, it will show that in November, similar is the function.

12
00:01:11,230 --> 00:01:13,060
Retail is equal to now.

13
00:01:15,430 --> 00:01:20,700
And you can see this includes the time also along with the date.

14
00:01:22,430 --> 00:01:28,010
Important thing to note here is, although actually showing us the time in readable format in the back,

15
00:01:28,010 --> 00:01:30,310
it maintains dates and times in no format.

16
00:01:31,310 --> 00:01:39,740
If it change the to number four, we can see that it is converted to remember the endangered part of

17
00:01:39,740 --> 00:01:44,240
this number is actually the count of days from first and nineteen hundred.

18
00:01:44,630 --> 00:01:50,950
So four plus Jan 19 under Disvalue will be one for December nineteen hundred.

19
00:01:51,320 --> 00:01:52,910
This value will be 365.

20
00:01:54,050 --> 00:02:02,060
Today is world number 2018, which is forty three thousand four hundred fifteen days from what, nineteen

21
00:02:02,060 --> 00:02:02,380
hundred?

22
00:02:03,050 --> 00:02:08,090
The decimal part denotes the time, so 24 hours will be one unit.

23
00:02:08,840 --> 00:02:13,490
For 12 hours, it will be 12 to 24 and one is equal 2.5.

24
00:02:14,500 --> 00:02:22,900
For six hours, it will be six by 24, which is point to five right now, it is for at 32 p.m., which

25
00:02:22,900 --> 00:02:28,200
is 16 hours, 32 minutes, which is coming out to be point six nine.

26
00:02:28,600 --> 00:02:35,550
Now, we will see some common daytime formats available in Excel or this date.

27
00:02:38,520 --> 00:02:43,740
If we want it in some other format, right, click on the Cell and Select for mental.

28
00:02:45,470 --> 00:02:53,750
In the category menu, we can select day to look at different date formats, we can select time in the

29
00:02:53,750 --> 00:02:57,410
category menu to look at different time formats.

30
00:02:58,780 --> 00:03:06,550
We can also create a custom format, go to type, click on custom, go to type, feel and maintain the

31
00:03:06,550 --> 00:03:14,460
format for debate related format if we want complete munt a m.

32
00:03:18,390 --> 00:03:19,710
Four year Bayway.

33
00:03:20,730 --> 00:03:22,980
And then time as it's Colin and then.

34
00:03:27,920 --> 00:03:29,210
Into the.

35
00:03:31,650 --> 00:03:36,270
We can see that the daytime value is now shown in the desired format.

36
00:03:37,560 --> 00:03:40,320
Next, we look at the mundane, yet formless.

37
00:03:41,920 --> 00:03:48,280
For any particular date, we can separate different parts of it using these formulas, so to get which

38
00:03:48,280 --> 00:03:53,950
day of the month it is a day and to liquidate.

39
00:03:59,220 --> 00:04:01,880
Today's world, they have no so.

40
00:04:03,400 --> 00:04:04,400
The solution?

41
00:04:07,330 --> 00:04:11,510
With the kind of month in any year use is equal to one selected it.

42
00:04:13,150 --> 00:04:14,600
November is the right one.

43
00:04:14,620 --> 00:04:16,270
So you are getting liminality.

44
00:04:18,460 --> 00:04:22,210
So to get your ear unselected.

45
00:04:24,250 --> 00:04:27,580
Are getting 2013 in this.

46
00:04:30,190 --> 00:04:35,920
Important operations that we usually need to do on and values involve finding the number of days between

47
00:04:35,920 --> 00:04:42,100
two dates or finding time difference between two time timestamps to find the number of days between

48
00:04:42,100 --> 00:04:47,660
two dates you can use is equal to days and to this date.

49
00:04:49,180 --> 00:04:51,850
This returns the number of days between the two dates.

50
00:04:57,350 --> 00:05:02,580
We can see that between 12 member and first number, there is a difference of 11 days.

51
00:05:03,440 --> 00:05:07,290
Similarly for the next case, there is a difference of four hundred forty days.

52
00:05:08,120 --> 00:05:11,000
You can also do this by simply separating the two dates.

53
00:05:15,830 --> 00:05:22,340
You can see it is giving us the same result, you can figure out why this well, by recalling that date

54
00:05:22,350 --> 00:05:29,150
and Excel captain, no farmer and the friends of those numbers and in the number of days they are apart.

55
00:05:30,490 --> 00:05:34,990
To get this different in us, multiply this value the 24.

56
00:05:38,930 --> 00:05:42,020
To get it in a minute, but then multiply it with 60.

57
00:05:50,650 --> 00:05:54,840
Third way to find difference in the due date is the data function.

58
00:05:55,950 --> 00:06:01,890
This function allows you to specify what you want in return, whether you want the days, months or

59
00:06:01,920 --> 00:06:06,600
years, four days we tape is equal to the different.

60
00:06:10,980 --> 00:06:11,760
Stardate.

61
00:06:15,450 --> 00:06:15,990
And the.

62
00:06:18,360 --> 00:06:23,070
Gonna be four days and four months and by four years.

63
00:06:39,930 --> 00:06:42,660
So you can see that in the second row.

64
00:06:44,180 --> 00:06:46,150
There is a difference of 15 months.

65
00:06:47,180 --> 00:06:48,650
Between the two they selected.

66
00:06:49,750 --> 00:06:52,960
Similarly, it can be done for getting the difference is.

67
00:07:00,230 --> 00:07:06,120
That's all for this lecture in the next lecture, you will discuss the index match and look functions.

68
00:07:06,950 --> 00:07:07,430
Thanks.