Weird format in a table cell

[Liliz]

Hello everyone.

I’m trying to calculate what week of pregnancy the user is and their progress (in percentage).
I created math columns, and it gives me weird formats (as on the picture)

When i double click on the cells, I see that the result is correct, but it doesn’t want to display it whatsoever. It only stays with the format 333:33:33.

Help please ?

[Jeff_Hager]

What you see is a number formatted as a duration in Hours:Minutes:Seconds.

Try Trunc(), Floor(), Ceiling(), or Round() in your math formula.