12 Replies Latest reply on Jun 2, 2014 12:29 PM by erolst

    Mimic excel time on a calculated value


      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?