Forum Discussion
Convert Time (H:MM) to a decimal number
I want to calculate the dollar per hour value using the following: 1) made a calculation of time worked using time formats 2) made a calculation of income from sources during that time frame 3)...
Yes, you do need to convert your time worked into decimal hours before dividing income by time. You can do the conversion manually using: hours + minutes/60 + seconds/3600. Or, if you prefer a faster and more accurate method, you can use this tool: https://timeindecimals.com/