AnsweredAssumed Answered

Mimic excel time on a calculated value

Question asked by mikebeargie Expert on Jun 2, 2014
Latest reply on Jun 2, 2014 by erolst

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?