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
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.
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.