Hi everyone, I’m using a Rollup field in Softr Database to sum durations. However, the result is returned in milliseconds (e.g., 145 hours appears as 522,000,000).
I need to convert this value into a readable ‘HH:mm’ format (Hours and Minutes). Since Softr Database formulas seem to lack functions like FLOOR, MOD, or DATETIME_FORMAT, how can I achieve this without getting ‘mismatched input’ errors or incorrect rounding (like negative minutes)?
Hi @karyne
In this case, I would offer you to use a Lookup field instead, and then have a Formula field in this table using the necessary formula that would work with the data of that Lookup field.
I realize this is from a while ago, but I was wondering if anyone has found a workaround or if there have been any updates in Softr that might help with this issue? Maybe someone has created a script or plugin that could simplify the conversion process since this was last discussed? Looking forward to any new insights!