Convert Hours & Minutes in Excel to decimals for billable hours by Chris Menard

preview_player
Показать описание
Time in Excel is tricky when you try to covert time to decimals. Example: 2:00 is two hours and zero minutes. Multiple 2:00 by $20 and you get 1.67 as a decimal. Two hours x 20 should be $40 billable amount. The trick is to multiply the hours and minutes by 24.

There are 24 hours in a day. Midnight in Excel is 0. 12 Noon or 12 PM in Excel is 0.5

Chris Menard's Website:

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!
Рекомендации по теме
Комментарии
Автор

Hey Chris, thanks for the demo. I find your explanation very valuable. I used the idea to calculate my self-study hours. I changed the rate to 1, so the hours converted to decimals. Once decimals were available, I was able to create a cumulative column plus a chart. It serves for me for crafting a look back on the hours that I dedicate to study in relation to my grades. Once again, thanks!

lestercarcamo
Автор

Thank you Chris you are a Quantum Excel Physicist! It has been surprisingly difficult to find a solution to what I thought has a relatively simple problem on the the web!

akinsamuel
Автор

Your videos are simple and straight to the point🙏🙏

mariag
Автор

Thanks Chris ... the x24 was what was escaping me ... used in Google Sheets! Thanks for a good simple computation!

imrnkhan
Автор

A lot of thank you... Many are skipping this step

nishikant
Автор

Very well explained, thank you! I saw a few videos before this and you nailed it with the explanation and process!

mariyamkhan
Автор

OMG. thank YOUUUU. i been looking for this answer forever.

lexy
Автор

Thanks for this video! I have to keep coming back to it because I keep forgetting! :)

Graphicious
Автор

I can’t thank you enough Chris, you save my time and thank you very much.

rso
Автор

Thank You very much🙏🙏. Your explanation is beautiful and straight to the point. No confusion at all and very easy to understand.

jamesmyrthong
Автор

Much appreciated ! Thank you for your time!

dianepoirier
Автор

Thanks for explaining how to calculate the hours in Excel. I have been trying for some time get this right, using the variouse suggestions relating to formating and the use of [brackets]. All to no avail. As soon as converted into a solved! Thank you!

johntrzan
Автор

Thank you very much for explaining this! I needed it.

JulieAnnStone
Автор

I did not expect that! Awesome thank you!

Cloppa
Автор

Thanks a lot for the video instruction!

tilllindemann
Автор

Thank you for this, it literally helped me with the report i am doing, thank you!

brownpotato
Автор

great videos, however I can across an issue. I have to calculate weekly time cards.

Monday 9:54 14:02 4:08
After Lunch 14:32 17:15 2:43
Daily Total 6:51
Tuesday 9:53 14:37 4:44
After Lunch 15:06 17:12 2:06
Daily Total 6:50
Wed 9:29 14:07 4:38
After Lunch 14:39 17:13 2:34
Daily Total 7:12
Thursday
After Lunch 0:00
Daily Total 0:00
Friday 9:30 13:34 4:04
After Lunch 14:05 17:02 2:57
Daily Total 7:01
Saturday
After Lunch
Daily Total 0:00
Sunday
After Lunch
Daily Total 0:00
TOTAL HOURS WORKED 27:54
Converted to Decimals for Payroll 3.90


My formula works great for all but when I convert them to decimals I do not get the correct hours if someone has worked over 24 hours. Here is my formula:

=IF((HOUR(D26)+MINUTE(D26)/60)=0, "", (HOUR(D26)+MINUTE(D26)/60))
The answer should be 27.9 noy 3.9

AJet
Автор

THANK YOU VERY MUCH SR THIS IS VERY WELL EXPLAINED ALSO I WOULD LIKE TO KNOW IF YOU CAN PLEASE HELP ME I USE A TIMECARD FOR WORK BUT THE PERSON WHO PAYS ME DO NOT ADD THE MINUTES CORRECTLY FOR ME 59 MIN ITS CLOSE TO ONE HOUR BUT FOR HER ITS HEALF BECAUSE SHE USES THE ACCOUNTING FORMAT BUT IN REALITY, SHE SHOULD BE USING A DIFERENT FORMAT FOR HOURS AND MINUTES

gqdmmko
Автор

Hey Chris. I need conversion for say 8.17 that runs in a report to convert to 8.28 for minutes to decimal hours. Help

allisonhiott
Автор

HI! sorry, i just found this video, and it helps me a lot. One problem, what if the time is from 11.30pm until 12.30am ? how we calculate the "1-hour" charge... tq sir

captsam