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

[Jb_Hanson]

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!

[Simon_Robinson]

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

[Steven_Coile]

AppSheet doesn’t support sub-second time resolution.

[Jb_Hanson]

Thank you