how to add hour in HH format

[shahnawaz_khan]

hi,

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

from input 07:00:00 to output 7

Input	Output
00:00:00	0
01:00:00	1
02:00:00	2
03:00:00	3
04:00:00	4
05:00:00	5
06:00:00	6
07:00:00	7

[shahnawaz_khan]

attaching data

[davidskaife]

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

[aatalai]

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))