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