Log In
Register
Home
March 10, 2016
Offline
In the attachment I want to summarize the hours
And an incorrect result is obtained
What to do??
See Answer
Trusted Members
December 20, 2019
Offline
All the data is text and not numbers (except the 22:00:00).
Sum can only work with numbers
March 10, 2016
Offline
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
Trusted Members
December 20, 2019
Offline
What are the numbers?
55:51 is that 55 hours 51 minutes or 55 minutes 51 seconds
March 10, 2016
Offline
55 hours 51 minutes
VIP
Trusted Members
December 7, 2016
Offline
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
Answers Post
1 Guest(s)
