I have already asked the same question here, only the question was wrong: I have to start from decimals. I don’t find any documentation on how to accomplish this anywhere. I am not an expert in this either.
So here’s the question:
I have records that contain time formats in decimals, eg: 0.50 (= 30 minutes), 8.00 (= 8 hours) etc. This is a formula field.
For a partner I have to convert this to the following format:
1.00 -> 0100
8.00 -> 0800
0.50 -> 0050
0.12 -> 0012
So 4 digits of which the first is a ‘0’. There should be no point in between.
Can anyone help me with this?
Thanks for your help!