[lovinfeelin]

basically on my spreadsheet i have a list of times in the following format

9.08 meaning Nine hours and Eight Minutes.


Next to it have a column with the decimal equivalent


Hours Decimal

9.08 9.13

this is currently calculated manually by just doing the simple calculation 8/60 = 0.13333333 and replacing the figure after the decimal with the new one, what i was hoping for was a way to calculate it automatically so that the decimal figure is produced without wasting time calculating the function manually and repeating.

[shades]

Howdy. You could name the number and use that in a formula, so that it could be automatic. Or write VBA code that could do the same thing. You would need some kind of trigger event.

[lovinfeelin]

i have come up with a basic solution in a roundabout way, im sure it wasnt ideal but it works and its just a simple thing, i only did it as iim leaving my job soon and was making it easier every way i can on the new person taking over.