“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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