1

00:00:00,740 --> 00:00:06,890

Hello there it's very important to keep track of time and that is the reason I'm taking this model where



2

00:00:06,950 --> 00:00:12,170

I speak about the form law today and now and also I'll show you a shortcut key.



3

00:00:12,260 --> 00:00:18,970

How do I end up getting beat God indeed and dine together depending on whether you are needed or current



4

00:00:18,970 --> 00:00:20,070

beat last time.



5

00:00:20,270 --> 00:00:25,590

So first things first a former lover says updates every time you open the workbook and there's form



6

00:00:25,640 --> 00:00:29,630

less going to be equal to the the good part about it.



7

00:00:29,630 --> 00:00:34,400

You don't need to edit any Panamera just need to close the bracket and press ENTER does it give you



8

00:00:34,450 --> 00:00:35,470

does it.



9

00:00:35,510 --> 00:00:42,160

Similarly there's a formula called now so in order blue Rackett open bracket closed and done you have



10

00:00:42,170 --> 00:00:49,040

generally used where you are considering today's date with a predefined date and time to find the difference.



11

00:00:49,040 --> 00:00:55,170

That means how many days have passed by since the due date and to date.



12

00:00:55,250 --> 00:01:01,130

Now let me also talk about the shot which allows you to enter today's date without you having to type



13

00:01:01,130 --> 00:01:03,270

that in and without the use of formula.



14

00:01:03,380 --> 00:01:09,110

So I wanted a static date and that's to be the side of the cell I press controls my colon and I press



15

00:01:09,170 --> 00:01:10,000

enter.



16

00:01:10,460 --> 00:01:16,010

Now if you want date and dined together then a combination of bouchal could use one as control semi-colon



17

00:01:16,370 --> 00:01:22,580

then press space then press controls shift so my colon that we give the current time for bed and time



18

00:01:22,580 --> 00:01:23,360

put together.



19

00:01:23,420 --> 00:01:25,020

You have to this day and time.



20

00:01:25,130 --> 00:01:29,460

So that was the formal approach as well as the short cut based approach.