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?
Let's say time worked is in cell T1.
The corresponding number of hours in decimal notation is given by
Format the cell with the formula as General or as Number.