00:00In my previous video, I demonstrated how to add minute to your time, but there were lots of
00:04complaints and chatter on the comment saying, oh my god, this is too difficult. Well, no worries.
00:10Here is a much easier way for you. We're going to start off with using a function called time,
00:16and then the first argument will be hours. We are not adding hours, we are adding minutes,
00:20right? So we're going to say zero, comma, and the second argument is minutes, which is going to be
00:25in cell C5, comma, and the third argument is zero, which is seconds. Close parenthesis and hit enter.
00:31You'll get a time of midnight, or rather 15 minutes past midnight. Remember, this is January 1st, 1900.
00:39It's pretty evident if you select the cell and you press control 1 to open cell formatting,
00:43and you format into a custom format this way to show year, month, day, and you can see it's
00:49showing January 1st, 1900. And also, one more thing, if you press control 1, it's basically
00:55a fraction of a day, which is 15 minutes in a day. This is evident. You go to general, you
01:01click OK.
01:02It shows as 0.01, which is 15 minutes of the day. Now to add 15 minutes, which is this
01:09fraction of a
01:09day, to your time, basically what you do is you're going to say B5, which is your cell where you
01:14have
01:14the time. You add it to your fraction of a day and hit enter. Voila, you can see that this
01:20time you
01:20have just added 15 minutes. And you can do the same technique if you want to subtract time. You
01:25basically change the operator from plus to minus. You can see the subtraction of the 15 minutes.
01:34And likewise, you can even add hours here if you like. And now to add, you just add 1 hour,
01:4015 minutes,
01:41and voila. There you go. I'm going to put this back to adding only the minutes so that it's obvious,
01:47like that. And now all you have to do to complete the task is to apply the same formula right
01:51across.
01:52And there you go. You're done.
