I'm trying to figure out how to do this in Metabase with the absence of a modulo operator. I feel like there's a pretty simple solution, but I'm just not grasping how to translate that into the custom expression field without a modulo.
I have two fields secondsa and secondsb, and I want to add them together and convert them into minutes and seconds. Right now, it's converting them into minutes plus the decimal remainder of a minute (i.e. 4.87 instead of 04:52). Is there any way I can convert this in Metabase so that it reflects that actual minute, plus seconds vs. the minutes plus the remainder of the whole of a minute? It's a table I can't query directly off of (I have to use the ask a question functionality) so I have to do it via custom expression. Thank you!
on the first post