Show Thousandth's of Seconds in Duration Field

[AdemarN]

I have a Time column that displays as such MM:SS.000 (Example: 01:44.315).
Appsheet is interpreting it as a “Duration” and is rounding it to MM:SS (Example 1:34)
I also have a column I labeled as TimeCalc that displays as 0.001238044 (which is the same as 01:44.315). Appsheet is also interpreting it as a “Duration” and is rounding it to MM:SS (Example 1:34)

How can I make Appsheet not round it and have it desplay the thousands?

I tried converting it to Text but then I loose Aggregate functionality.

Thanks,

[Suvrutt_Gurjar]

I think Appsheet time and duration formats do not currently support thousands of seconds.

If it is a must, you may wish to explore calculating duration math on MM:SS part of time /duration and fraction seconds part .sss separately and then adding those.

However, such math and resultant expressions will be a bit complex.

[Steve]

AppSheet has no support for time resolution below whole seconds.