00:00All right, here's part two on how to add unit of time measurement to an existing time.
00:04This time around, we'll tackle how to add hours, minutes, and seconds to your existing time.
00:10As we have highlighted before, you can't simply take an equation of time plus hours plus minutes plus seconds.
00:20It will not give you the correct answer.
00:22Like before, essentially, there are two ways of getting around this question.
00:26The first method entails converting hours and minutes and seconds to a fraction of a day.
00:32Let me explain.
00:34C3 divided by 24 converts hours to a fraction of a day.
00:37And you add that to D3 divided by 24 times 60, which is 1,440 minutes in a day.
00:45And then you take E3 divided by 86,400 seconds in a day.
00:50And you add this fraction to your time in B3.
00:54It will yield the updated time.
00:56After that, you apply the same formula right across every row, and you are done.
01:00That is method number one.
01:01Method number two is a bit straightforward.
01:03You simply use a time function.
01:05The first argument on a time function will be your hours.
01:08And the second argument will be your minutes.
01:10And the third argument will be seconds.
01:12And you take the output of the time function, and then you add it to the time on cell B3.
01:18And then you'll get your answer.
01:20And then apply the same formula right across every row.
01:22And you'll see what happens.
01:22And I'll choose me.
01:24And then we'll feed it.
Comments