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.

 

[jinasalcedo]

I am trying to convert decimal numerals to minutes.

The whole number is the number of hours and I don't need to convert those. Only the decimal portion.

113.62 to 113:37

Thanks for your patience!

 

[jasonb75]

I am trying to convert decimal numerals to minutes.

The whole number is the number of hours and I don't need to convert those. Only the decimal portion.

113.62 to 113:37

Thanks for your patience!

See post #9

format cells as [h]:mm:ss

 

[VoG]

Custom format [m]:ss

Excel Workbook
	A	B
1	113.62	113:37
Sheet5

 

[jinasalcedo]

Finally!

Thanks much! You're so smart!

 

[jasonb75]

Custom format [m]:ss

Excel Workbook
	A	B
1	113.62	113:37
Sheet5

That actually equates to 113 minutes 37 seconds, not 113 hours 37 minutes!

See my previously overlooked replies for the correct version.

 

[VoG]

That actually equates to 113 minutes 37 seconds, not 113 hours 37 minutes!

See my previously overlooked replies for the correct version.

Are you saying that my result is incorrect? In what way?

 

[barry houdini]

mmm.....

I think you're both wrong

converting decimal hours to a time value.....divide by 24, format as [h]:mm

 

[VoG]

Doh.

I guess that 24 is slightly different to 1440

 

[jasonb75]

mmm.....

I think you're both wrong

converting decimal hours to a time value.....divide by 24, format as [h]:mm

Thanks barry, could have sworn that was what I'd said, had /24 on the sheet where I tested the result but stupidly typed it in wrong here instead of using copy paste

Peter, see #10

Whole number is Hours, not Minutes, which was what your formula works on.

 

[jinasalcedo]

I changed it to [h]:mm, but calculating incorrectly. So I went back to [m]:ss as long as I can convert my numbers it doesn't matter if it is not hours and minutes, unless there is a right formula that will calculate using format [h]:mm.

Thanks for all the help.