Hello. I would like to keep track of my time per project. I have a date field that has a start and end time. I can get the total minutes using:
format(dateBetween(end(prop("Clock-In Clock-out")), start(prop("Clock-In Clock-out")), "hours")) + "hr " + format(dateBetween(end(prop("Clock-In Clock-out")), start(prop("Clock-In Clock-out")), "minutes") % 60) + "min"
However, this gives me x minutes in the column that can not be added as a summary. How can I convert the value to a numeric value (minutes is OK, Hours and Minutes will be better).
Thank you...
MK