I’m glad that worked for you! If your hours field was an integer rather than datetime data type then I’m not sure why it didn’t allow you to sum properly.
That being said there are ways to work around those issues with Ifelse statements and nested aggregations. I recommend checking out this post: