Hey everyone,
How do you change a general value to time?
For example in my data sheet I have the value: 0,815. This value is basically a portion of an hour. But when I change the number format to [hh]:mm:ss it turns into 19:33:36. while it should be along the lines of 48min. I can see the number I get is based upon 24 hours, but I want it to be based on 1 hour.
How do I fix this?
