I have a calculation that results in a number, and I'm trying to duplicate excel's handling of the same formula.
Sample of the formula:
10.80 / 24 / 60 = 0.0075
In excel, the cells are formatted to display hh:mm:ss, with the resulting time displayed from the above calculation as 0:10:48.
In Filemaker I can return the same 0.0075, but am having trouble converting that into the time as noted above.
I know I'm probably missing an obvious multiplier or formula here, what is it?