Change Decimal Time Format

[Erwin_Van_den_B]

Hi there,

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
etc.

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!
Erwin

[Nick_Dennis]

The only way I know to always get 4 digits, starting with an unknown number of 0s, would be to turn the number into a string. Also note that this format limits the time measurement to 4 digits, so anything over 99.99 hours will not show up correctly.

Give this a try:
RIGHT(CONCATENATE("0000",ROUND({time} * 100, 0)), 4)

Replace {time} with your own starting variable.

[Erwin_Van_den_B]

Yes, that works. Thank you!