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

(Jb Hanson) #1

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) #2

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) #3

AppSheet doesn’t support sub-second time resolution.

(Jb Hanson) #4

Thank you