How to convert decimal number to minutes

[jinasalcedo]

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.

 

[Scott Huish]

It has already been posted.

=A1/24

Format as [h]:mm

Excel Workbook
	A	B
1	113.62	113:37
2	167.69	167:41
3	179.47	179:28
4	240	240:00
Sheet1

 

[jinasalcedo]

Yes, I realized it yesterday. Thanks for the clarification.
I'm so dumn..ha ha