Hi,
I am using SeaTable Cloud and I need a column of type duration.
But I can only choose between hh:mm and hh:mm:ss.
But what I need is mm:ss.<1/100s>
Any hint on how to achieve that?
Many thanks
Michael
Hi,
I am using SeaTable Cloud and I need a column of type duration.
But I can only choose between hh:mm and hh:mm:ss.
But what I need is mm:ss.<1/100s>
Any hint on how to achieve that?
Many thanks
Michael
at the end, what I did, is to combine 2 columns:
one as whole number for minutes and one as number with format 1.00 for seconds.
Then I combined both columns as text in the format I needed mm:ss.00, and
I needed even one more column combining both columns as a single number for comparisons and stats.
Quite annoying for such a simple stuff.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.