# Converting HH:MM:SS to hours in decimal

#### njsutorius

##### New Member
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

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### jim may

##### Well-known Member
A1 = 32:44:00

A2 =A1*24 should display your 32.7333

Format cell A2 as General

Last edited:

#### njsutorius

##### New Member
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

##### Well-known Member
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.

Replies
5
Views
448
Replies
3
Views
305
Replies
0
Views
238
Replies
4
Views
408
Replies
5
Views
478

1,129,472
Messages
5,636,516
Members
416,920
Latest member
Riskyplan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back