Can anyone tell me how to format time recorded in the time tracking column (eg 2h 55m) as a numer?

Hi all,

I am trying to take the time recorded in a time tracking formula (eg 2h 55m) and convert it to a plain number with .00 accuracy (eg 2h 55m would be converted to 2.92 (hours). I have tried a few formulas but no joy so far. (The reason I want to convert the time tracking to a plain number is so I can multiply it by another number in a formula to calculate the value of time worked).

TIA Patrick


It’s pretty simple:

ROUND({Time Tracking#Hours},2)

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas - Part 3: Dates/Times, Strings and Status