How can I Convert Decimals to Fractions
I've been racking my brain trying to write a calculation that returns a fraction from a decimal. I've seen the calculations which convert decimals to fractions, but not the other way around. I'm creating a photo library and when I import the metadata from the image it displays as a decimal. Unfortunately, I don't relate 0.00625 as being 1/160 of a second. It's not a quick read. I also need the formula to calculate longer exposures, it would be fabulous if the same calculation field could correctly display 1 min 32 sec. or 15 sec. or 1/5000 sec. depending on what the actual shutter speed was. The imported number is formatted as .00625 which I have been able to convert into a time format as 0:00:00.159999 using the calculation .001 / Exposure Time
Any one up for the challenge? Your help would be greatly appreciated!