Converting Time represented as a whole number to proportion of working day

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?


Here’s one way:
FORMAT_DATE(ADD_MINUTES("1/1/1", {Time Recorded} * 60), "HH:mm")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Creating subitems using Make/Integromat The Monday Man (EASY) Way
Contact me directly here: Contact – The Monday Man

Thank you so much, this has worked perfectly for what I need.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.