I work on European Funded Projects and have to collect time spent on the various tasks and work packages from researchers. I have created a basic form which ask them to declare their time spent on a task as a number e.g. 2h15m is inputted as 2.25. (as there is no option to enter time in the form question types.
I have then set up a formula column to convert this to minutes:
MULTIPLY({Time Recorded },60)
so 2.25 becomes 135 mins
But I need convert this to HH:MM and cant figure out how. Does anyone know how to do this?