Forum Discussion

alan1959's avatar
alan1959
Copper Contributor
Aug 25, 2020

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)...
HansVogelaar's avatar
HansVogelaar
MVP
Aug 25, 2020

alan1959 

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.