00:00Today I've got a really cheap trick for you. How do you add minutes to a time in Excel?
00:04Well, this is how I do it. You're going to start off by saying equal 24 times 60,
00:09which is going to give you the number of minutes in a single day. Now to convert your 15 minutes
00:14into a fraction of a day, we take the value in cell C5, which is 15, divided by 24 times
00:2160.
00:22And this is going to amount to a value of 0.01. And if we add this fraction of a
00:27day
00:28to the time in cell B5, this effectively adds the minute from cell C5 to the time in B5.
00:35Cool, isn't it? Let's finish off by applying the same formula for the rest of rows, and then you're done.