How to format Softr Database Rollup (milliseconds) into Hours and Minutes?

Ask the community
1

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)?

2

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.

1 Like