Converting HH:MM:SS to hours in decimal

[njsutorius]

Hello,

My system records the number of hours a employee is logged in per week and displays them as hh:mm:ss. I want to convert this to a decimal so i can then divide by the number of calls they took for the week to determine the calls per hour.

I know how to manually convert the time to decimal, but i cant get excel to recognize it properly. When i use the INT formula it does as follows:

<colgroup><col width="64"></colgroup><tbody>
</tbody>

32:44:00

<colgroup><col width="64"></colgroup><tbody>
</tbody>

converts to 8.73. it should just be 32.73333 . I feel like im overlooking something extremely easy, but i cant seem to get excel to separate the hours and minutes.

P.S. i don't care about seconds so its fine to drop those off if that makes it neater.

Thanks

 

[jim may]

A1 = 32:44:00

A2 =A1*24 should display your 32.7333

Format cell A2 as General

 

[njsutorius]

A1 = 32:44:00

A2 =A1*24 should display your 32.7333

Format cell A2 as General

Sometimes i get embarrassed when i have to post on here.

Consider this one resolved.

 

[mfexcel]

No need to be embarrassed. The fact is many people don't have a proper understanding of how Excel stores data and time.
A short article for your reference
Do you need TIME? | wmfexcel

Sometimes i get embarrassed when i have to post on here.

Consider this one resolved.

 

[njsutorius]

Thanks again. great read.