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.

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.

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.