Math Column showing result wrong

I have a math column. I am working out a timestamp - Start Time to get the length of time or duration. The app/column keeps showing the format in a date and time format rather than a duration format. All other tables are represented right, just this one is refusing to show duration.

Can you share a screen shot that shows all 3 columns please?

1 Like



The problem is with your Gun Start lookup column. It’s returning an array, and that won’t work properly in your math formula.

I suspect that your EventRace relation column is a multiple relation. The solution is most likely just to change that to a single relation.

2 Likes

Thanks.