Time format

[#1]

Hi QV team,

These are actual dates.

0

400

450

600

645

730

1000

1200

1230

I require above dates like this.

00:00

04:00

04:50

06:00

06:45

07:30

10:00

12:00

12:30

Thanks,

Krish

[#2]

Hi Max,

I did try but did not get 00:00 instead of 0 date.

[#3]

Hello Naidu,

This may help to you

left(fieldname,2) & ':' & right(fieldname,2)

Thanks

Harsha

[#4]

Hello Naidu,

Correct it

num(left(fieldname,2),'00') & ':' & num(right(fieldname,2),'00')

Thanks

Harsha

[PrashantSangle · Accepted solution]

Hi,

add nested if() in provided solution.

IF(LEN(TEST_TIME)=3,TIME(Time#(TEST_TIME,'hmm'),'hh:mm'),if(LEN(TEST_TIME)=4,TIME(Time#(TEST_TIME,'hhmm'),'hh:mm'),TIME(Time#(TEST_TIME,'m'),'hh:mm')))

Regards

[#6]

Hi Max,

Thank you for gave correct answer.