Convert decimals to time in Excel by Chris Menard

To make 7.5, which is a decimal to 7:30 as hours and minutes, you simple divide 7.5 by 24 and format the cells as h:mm.


Providing Excel training in Atlanta, Cobb County, Gwinnett County, Roswell, Smyrna, and other locations.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[Luss]

Thank you very much, man. I've been trying to do that for almost two weeks, not understanding where the mistake was. Thanks to your video I could resolve the problem in less than 5 minutes. Congrats. Just got another follower. Greetings from Brazil, Sao Paulo

[Peprmint]

Thank you so much for the step by step instructions!! This is exactly what I needed 👍

[budshoot]

Just dropping a comment to let you know this video is still saving lives 6 years later! Okay maybe a bit of an exaggeration but it really did help me VERY QUICKLY with an issue so Thank You!

[hayden]

Perfect, to the point explanation. It is help like this that makes me enjoy using excel so much

[Neptune]

Thanks Chris, Nice keyboard commands.
I do have a system where I just put in numbers for start and finish time (e.g 730 instead of 7.5) and the spreadsheet does the rest. Entering information is simple in my system but it does require a commencement date to set it up. The date is combined with the start and end time to accommodate night shift workers.
Thanks again, Colin

[emmasavant]

Clear and to the point. Thank you so much!

[jamesmyrthong]

Thank You so much. I was looking for this one the whole day. 💯💯💯💯💯👍👍👍👍

[SirJamesLester]

Ahh thank you so much! This was so simple, but absolute time saver

[fernandoaguirre]

Great!!! Saved my life!!! Thank you, very much.

[jailankeshwer]

Super next level...
Extremely easy to use.. Thankyou so much much...

[meniiix]

wait i think this is the answer i was looking for. thank you!

[alexfreeburn]

Thank god I found this I search this up and always converts with decimal time real life saver

[kristenbyu]

Also, how would you ignore if it's a negative number when totaling hours (i.e. the employee is over time.)

[kristenbyu]

What do the brackets around the h mean [h] ?

[tonytaf]

Any suggestions to covert for example: 1m 30s to 1.5 or 4m 30s to 4.5 ???? Please

[danielaaguilera]

what about the other way around? I want to convert the hours they worked 77:56 to decimal

[BobbyHTTC]

Why does my formula change to 928:00 when I changed the format [h]:mm?

[samiaghezal]

Thank you! Could you explain the logic behind 24?

[taslimsalaudeen]

How do I convert 1.7 (when the work hour is above 24)?

[DanYT]

And what would it be like with ", "?