How can I convert my timer to total hours

Platform discussions
, ,
1

I have a time tracking column call Actual effort how can I convert it to total hours, I would like to see total hours worked

2

Hi @AlmogK - you can use a Formula column with the following: ROUND({Actual effort#Hours},0). If you want to see it as a decimal just remove the ROUND() function.

Hope this helps!
Mark

3

thats that is great is there a way to format it a bit better for example add hrs at the end and right now i get for example 0.433 or 0.746 if I use round I its incorrect and I miss the minutes

4

Hi @AlmogK - you can use the ROUND() function and choose the number of digits. So if you want to see minutes you could use ROUND({Column},2) or just not use ROUND() at all.
Mark

5

thanks this is great