Convert time from format 1.xx or 0.xx hours to x hours and xx minutes or xx minutes

I store hours in decimal form.

I would like a simple script that would take hours stored in xx.xx format and convert it to plain text hours/minutes

for example 1.5 would become "1 hour and 30 minutes"

0.5 would become "30 minutes"

etc.

No rounding is required, for example:

0.63 would become 21.6 minutes, etc

Originally Posted by daffodil11

How about this? This is a worksheet change event that runs automatically as you enter data. It has the focus set to A1:A50, and will only attempt to change cells with numbers in them, as opposed to strings.

Please Login or Register  to view this content.

Unfortunately I can't work with a worksheet change because data is calculated off the cells. Unless there is a way to somehow "display" the converted value while keeping the original value the same for calculation purposes.

The method I had in mind was something along the lines of:

Please Login or Register  to view this content.

I think that script would work, I just don't know how to tell Excel to do "if whole number" or get it to refer specifically to numbers before or after the decimal, regardless of the length of digits.