Hello, Is there a way to change duration for...

Hello,

Is there a way to change duration format to mm:ss.0?

For example, my spreadsheet reports 3 minutes and 12.5 seconds as 3:12.5.

How can I get AppSheet to report the decimal?

Thank you!

0 3 338
3 REPLIES 3

Not really.

You could display it that way by creating a formula to calc โ€œ3:12โ€ and another to calc โ€œ.0โ€ then concatenate them together.

But you canโ€™t select it like that in one column, but you could in 2 columns

AppSheet doesnโ€™t support sub-second time resolution.

Thank you

Top Labels in this Space