Get instant live expert help on decimal to minutes
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Looking to have Lat. Long in - Degrees Minutes Decimal Minutes
120* 23.2345'
Can you do that?
Solved by O. H. in 26 mins
I need a formula that turns minutes into decimal minutes. ie: if someone works 53 hrs and 49 mins that week I need it to read 53.82
Solved by X. J. in 16 mins
I need a formula that will convert hours worked into decimal format without seconds. Ex. 9 hrs and 18 minutes (9:18) worked converted to 9.3
Solved by V. S. in 13 mins
I want to get 6 and a half hours into a decimal so it becomes 6.5. I need it as an equation so if I change it to 7 hours and 45 minutes it changes to 7.75 automatically.
Solved by F. B. in 26 mins
trying to create a timesheet calculator for calculating my hours. I only have 20 hrs a week but they round down the number in increments of .25 or 15 minutes. For Example, if one day I only worked for 6 hours and 10 minutes (which is about 6.22 in decimal) but since I hadn't worked the full 6.25 hours it rounds the hour to 6.00 instead. so I'm wondering how to tell it to round down in increments of 0.25. any ideas?
Solved by C. C. in 14 mins