How to change general values to time?

%3CLINGO-SUB%20id%3D%22lingo-sub-2860377%22%20slang%3D%22en-US%22%3EHow%20to%20change%20general%20values%20to%20time%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2860377%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20you%20change%20a%20general%20value%20to%20time%3F%3C%2FP%3E%3CP%3EFor%20example%20in%20my%20data%20sheet%20I%20have%20the%20value%3A%200%2C815.%20This%20value%20is%20basically%20a%20portion%20of%20an%20hour.%20But%20when%20I%20change%20the%20number%20format%20to%20%5Bhh%5D%3Amm%3Ass%20it%20turns%20into%2019%3A33%3A36.%20while%20it%20should%20be%20along%20the%20lines%20of%2048min.%20I%20can%20see%20the%20number%20I%20get%20is%20based%20upon%2024%20hours%2C%20but%20I%20want%20it%20to%20be%20based%20on%201%20hour.%3C%2FP%3E%3CP%3EHow%20do%20I%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2860377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2860474%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20general%20values%20to%20time%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2860474%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1189573%22%20target%3D%22_blank%22%3E%40ietsverzinnen%3C%2FA%3E%26nbsp%3BWell%2C%20divide%20the%20number%20by%2024%20first.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

1 Reply

@ietsverzinnen Well, divide the number by 24 first.