Format total hours worked
Hi. I have a formula that returns the total of hours workeed. For example, starting at 10 am and end at 14 pm returns 4:00. Anyway to format the 4:00 to 4? I want to make the sum of total of hours worked, but with the 4:00 format can't.
Okey I have this formula
sum((select Febrer).'Hores ordinàries')
But it retunrs "3 days 8:00". How to format to total hh:mm?
- 3 yrs agoLast active