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?

Outcomes