how to add hour in HH format

Question

hi,

I have attached the input and also the output which I required.

from input 07:00:00 to output 7

InputOutput00:00:00001:00:00102:00:00203:00:00304:00:00405:00:00506:00:00607:00:007

aatalai · Answer

I would say @davidskaife is the most efficient; if you want to avoid using the datetime functions then something like this will also work

IIF( left(left(ToString([Input]),2),1)="0", right(left(ToString([Input]),2),1),left(ToString([Input]),2))

davidskaife · Answer

Hi @shahnawaz_khan

DateTimeFormat formula will do it:

Use %k instead of %H if you want to have the output as one digit (0, 1, 2 etc) but it adds a space before so will need tidying up

shahnawaz_khan · Answer

attaching data