Converting HH:MM:SS to hours in decimal

njsutorius

New Member
Joined
Apr 6, 2014
Messages
43
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
Joined
Jul 4, 2004
Messages
7,484
A1 = 32:44:00

A2 =A1*24 should display your 32.7333

Format cell A2 as General
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top