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

    Mimic excel time on a calculated value

    mikebeargie

      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?