Oct 19 2021 03:34 AM
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?
Oct 19 2021 03:59 AM
@ietsverzinnen Well, divide the number by 24 first.