Convert Time (H:MM) to a decimal number

%3CLINGO-SUB%20id%3D%22lingo-sub-1611957%22%20slang%3D%22en-US%22%3EConvert%20Time%20(H%3AMM)%20to%20a%20decimal%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611957%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20calculate%20the%20dollar%20per%20hour%20value%20using%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20made%20a%20calculation%20of%20time%20worked%20using%20time%20formats%3C%2FP%3E%3CP%3E2)%20made%20a%20calculation%20of%20income%20from%20sources%20during%20that%20time%20frame%3C%2FP%3E%3CP%3E3)%20want%20to%20divide%20the%20income%20by%20the%20time%20worked%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20I%20need%20to%20convert%20time%20to%20decimal%20%3F%20How%20can%20I%20convert%20time%20to%20decimal%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612001%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20Time%20(H%3AMM)%20to%20a%20decimal%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612001%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771027%22%20target%3D%22_blank%22%3E%40alan1959%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20time%20worked%20is%20in%20cell%20T1.%3C%2FP%3E%0A%3CP%3EThe%20corresponding%20number%20of%20hours%20in%20decimal%20notation%20is%20given%20by%3C%2FP%3E%0A%3CP%3E%3DT1*24%3C%2FP%3E%0A%3CP%3EFormat%20the%20cell%20with%20the%20formula%20as%20General%20or%20as%20Number.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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?

1 Reply
Highlighted

@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.