0

How to show hours spend on something

Ok, I know how to do a 'sum' to get all time spend on a project added up.
But when it exceeds 24 hours, I get (for example) '1 Days 8:30' wich is actually 32:30 hours.
How can I get it displayed as 32:30 hours?

2 replies

null
    • Support
    • 6 yrs ago
    • Reported - view

    Hi, 

    There are two possibilities: Wether you adjust the number format of your time intervall field to only hours

    or you use the following formula to format the output as number in your wished format: 

     

    time(number(sum((select table).duration)) / 3600000)

     

    Best, Jörg

    • toon
    • 6 yrs ago
    • Reported - view

    Thank you, I'll have a look at it.

Login to reply

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 1321Views