Rounddown function

[Project_NP_LS]

Hello Airtable community.

I am trying to move my excel spreadsheets across to Airtable and would welcome any help with the Rounddown function. In Excel, it looks like this **=(ROUNDDOWN(C5,0)6)+((C5-(ROUNDDOWN(C5,0)))10)

For anyone who is a cricket fan, I am looking to convert overs which consist of a max of 6 balls into total number of balls bowled. So for example, 8.4 overs = 52 balls (8 overs of 6 balls each = 48 + the 0.4 which is actually 4 balls, therefore 52.

The excel formula above works perfectly but I am struggling to convert it into an Airtable formula.

I have attached an image for ease of reference.

Any help welcome.

Best

Ladi

[Project_NP_LS]

Formatting Duration

Using the formula field to display the duration field works well. Thanks for that tip.

Alignment

Shame about alignment but good to know all the same.

Thanks a lot