Question

I have a table for tracking how much time I spent on reading every day. I want to record in minutes for calculating the sum, is it possible to change the format into something like 2h30m with formula?

Thanks in advance.

Answer 1

The solution is to count the number of hours and minutes. You can do it with a formula and this example may help you.

format(floor(prop("time worked") / 60)) + "h" + format(prop("time worked") - floor(prop("time worked") / 60) * 60) + "m"