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) want to divide the income by the time worked
Do I need to convert time to decimal ? How can I convert time to decimal?
2 Replies
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/
Let's say time worked is in cell T1.
The corresponding number of hours in decimal notation is given by
=T1*24
Format the cell with the formula as General or as Number.
