How to convert decimal number to minutes

jinasalcedo

New Member
Joined
Feb 2, 2011
Messages
16
I am tracking paid time off in excel. We have been using a decimal fraction of a minutes like .5 fro 30 minutes. But since we started using quickbooks payroll, qbs used 30 minutes (1:30) for 1.5.

How do I convert my data from 1.5 to 1:30 in excel spreadsheet? Any idea?

Thanks.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Me again..it didn't calculate for other cells, only the first one. See below;
33.98 to 33:58 is correct but the rest are wrong.

<table border="0" cellpadding="0" cellspacing="0" width="230"><col style="width: 59pt;" width="78"> <col style="width: 48pt;" width="64"> <col style="width: 66pt;" width="88"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt; width: 59pt;" height="17" width="78">Ending Balance</td> <td class="xl65" style="width: 48pt;" width="64">
</td> <td class="xl69" style="width: 66pt;" width="88">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="border-top: medium none; height: 12.75pt;" height="17">33.98</td> <td class="xl65">
</td> <td class="xl69" align="right">33:58.9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="border-top: medium none; height: 12.75pt;" height="17">33.98</td> <td class="xl65">
</td> <td class="xl69" align="right">33:58.9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17"> </td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl65" style="height: 14.25pt;" height="19">
</td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl65" style="height: 14.25pt;" height="19">
</td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">Ending Balance</td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="border-top: medium none; height: 12.75pt;" height="17">113.62</td> <td class="xl65">
</td> <td class="xl69" align="right">53:36.9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="border-top: medium none; height: 12.75pt;" height="17">167.69</td> <td class="xl65">
</td> <td class="xl69" align="right">47:41.5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">
</td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl65" style="height: 14.25pt;" height="19">
</td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl65" style="height: 14.25pt;" height="19">
</td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">Ending Balance</td> <td class="xl65">
</td> <td class="xl69">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="border-top: medium none; height: 12.75pt;" height="17">179.47</td> <td class="xl65">
</td> <td class="xl69" align="right">59:28.3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl67" style="border-top: medium none; height: 12.75pt;" height="17">240.00</td> <td class="xl65">
</td> <td class="xl69" align="right">00:00.0</td> </tr> </tbody></table>
 
Upvote 0
I did but still not right. I noticed that if the hours is below 60, the calculation is correct but if the hours is more than 60, it is calculating incorrectly.

113.62 is 113 hrs and .37 minutes , should have been 113:37, right?
 
Upvote 0
Should be =A1/60 not =A1/1440

You were converting to minutes and seconds not hours and minutes.
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

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