In the attachment I want to summarize the hours
And an incorrect result is obtained
What to do??
All the data is text and not numbers (except the 22:00:00).
Sum can only work with numbers
The hours here are retrieved with a formula from another file.
Here is the original file of the hours I received from the software.
I tried in Power Query to convert it to an hour format
And it brings an error message Error
How can this be arranged? Thanks!!
Thanks for the reply, Leah
What are the numbers?
55:51 is that 55 hours 51 minutes or 55 minutes 51 seconds
55 hours 51 minutes
Hello,
If you haven’t already, do check out the blog section on this site, it contains lots of good and useful articles.
See attached file. I used the TIMEVALUE function, formatted to show elapsed time in hours.
Br,
Anders
