52.1 F
San Francisco
Saturday, November 21, 2020

Convert hh:mm:ss to Hours, Minutes, Seconds in Excel

I was stuck trying to figure out some Excel formulas because my data set decided to capture how long something takes into the format hh:mm:ss. At the same time, Excel and many other programs view that format as time of day.

This is for example, how long did it take you to build the fence? 10:05:30. As in 10 hours, 5 minutes, and 30 seconds. Excel will read this as 10:05AM and 30 seconds. Doing analysis on is strange because people really just want to know how long it took in terms of minutes or hours and adding times will not produce the results you would like. Adding time works but when you would like to add 15 minutes to hh:mm:ss it can get complicated.

Here’s the quick and dirty solution

In order to get from hh:mm:ss to a solid number you can use the following formulas:

hh:mm:ss * 24 = TOTAL NUMBER OF HOURS (you might want decimal points)

hh:mm:ss * 1440 = TOTAL NUMBER OF MINUTES (you might want decimal points)

hh:mm:ss * 86400 = TOTAL NUMBER OF SECONDS

To take out the individual hours, minutes, seconds

In Excel, if you just want the hours from hh:mm:ss, the formula is:

=hour(cell where the data is located)

In Excel, if you just want the minutes from hh:mm:ss the formula is:

=minute(cell where the data is located)

In Excel, if you just want the seconds from hh:mm:ss the formula is:

=second(cell where the data is located)

Here’s the long way to convert time

Edel Alonhttp://edelalon.com
Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.

Related Articles

Driving Home For Christmas? Mind The Snow!

Winter is coming and that means one thing: Christmas! you may be planning a trip home for Christmas this year, in the middle of...

5 Simple Tips to Jumpstart Your Healthy Diet Plan

Starting and sticking to a health and wellness plan is an overwhelming yet rewarding journey. A healthy diet plan will significantly improve your physical...

Why People Give Up On Their Vegan Diet (And How You Can Stick To Yours)

Veganism is becoming so popular and a lot of people that never would have considered it before are trying to go meat-free. But even...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Stay Connected

440FollowersFollow
9,970FollowersFollow
17SubscribersSubscribe
- Advertisement -

Latest Articles

5 Simple Tips to Jumpstart Your Healthy Diet Plan

Starting and sticking to a health and wellness plan is an overwhelming yet rewarding journey. A healthy diet plan will significantly improve your physical...

Why People Give Up On Their Vegan Diet (And How You Can Stick To Yours)

Veganism is becoming so popular and a lot of people that never would have considered it before are trying to go meat-free. But even...

Is There Cost Savings by Installing a Bidet?

Thanks to COVID and the presidential elections, I feel like we are going to get into another toilet paper outage. In fact, my last...

Gifts For Tech Loving Kids This Christmas

Planning for Christmas during covid is more than a challenge for many of us as it will stop us from spending time with the...

Are You Making The Most Of Your Smartphone?

Whatever kind of smartphone you have, you have to agree that it is an incredibly useful tool. Without it, so many things would be...