00:00Have you ever wondered how do you add minute to your time? You can't simply take minute and add it
00:07to your time like this. This will not yield a correct result. Well technically there's two
00:12ways to do it. The first way is to take your minute divided by 1440 like this. 1440 is the
00:21number of minutes in a single day. And then you take the output for that division and you add it
00:26to time and that will yield the correct result for you. That is method number one. Method number two
00:34is essentially using a time function. A time function has three arguments in it. The first
00:39argument is for hours. I'm going to apply zero for that because I'm adding only minutes. And then the
00:45argument is your minutes in cell C3 of 20 minutes. And the third argument is seconds. Since I don't
00:51have seconds I'm going to assign it to zero and close parenthesis. After that you're going to take
00:56the output of the time function, add it to your time on cell B3 like this. And after that you
01:03can
01:03apply it to the rest of the row like this. But the secondary question to that is this. How do
01:08you add
01:08hours and seconds along with minutes to your time? That's going to be featured in my next video.
01:15Please stay tuned.
Comments