How to Convert Time to Number in Excel - Tutorial

Excel tutorial on how to convert time to number in Excel.

You may need to convert time to a number in Excel to calculate time worked or when you need to multiply total time worked by a currency to calculate pay, for example.

In this tutorial, you'll see how to convert time from hours, minutes, and seconds to a decimal number.

*FYI:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

[Knowledge_Active]

Thankyou you saved my employess incentives ❤

[That_Koding_Guy]

Thank you, this video has saved me out of hours of pain

[multipurpose]

OMG I wish I had found your channel years ago. this has helped tremendously

[sherek]

thanks, the 24* trick has made it for me.

[cinfulgentleman]

This helped me get over the brain gap I had while reading a bunch of other solutions! Thank you very much! It worked perfectly.

[mohammedmohsin]

This helped me plan my study schedule. Thanks a lot :)

[abhayraj]

Thank you so much MAM 👍 my problem Solved only You.

[kriszzzztube]

Great tutorial. I would like to know how you do the opposite of this? Converting from number to time (hours & minutes)

[jamesrobert]

it's Amazing and Helpful information Thans.

[CNCHobby]

This is incredible....Well done and thank you so much for sharing.

[mohamadabdouni]

Thanks a lot. Easy, clear, and helpful.

[MohamedOmar-ydne]

Thank you so much, please keep posting videos <3

[itingchristinatrout]

I use Google Sheets, there's no comma style in the number format. Help

[stanlyjohnpeter]

After 4 digit value hours its coming error, ex 5 digit value (13526:00) hrs not able to change please advise,

[learntocodele]

but like this number 10:00:00 getting 00:00:00 for me. How can i fix this??

[tonytaf]

How to covert for instance 1m 30s to 1.5, 2m to 2, 4m 30s to 4.5 and so on????
I had this today during an evaluation. Totally messed up this part.

[DavidKlenkFurniture]

How do I set up a time sheet that calculates hours worked?

[tinashemukota]

This is not what I am looking for. I want to convert 00:00 to 24, or 07:00 to 7, etc. to represend time just as 1, 2, 3, 4...24.

[cold_depression]

Huh o many views by no WORLD DO WE LIVE IN!?