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

[PrashantSangle]

Hi,

Use Time(alt(Time#(FieldName,'mss'),(Time#(FieldName,'mmss')),'mm:ss')

Regards

[sunny_talwar]

Are these Hours and Minutes or Minutes and Seconds??

Best,

Sunny

[#4]

Hi,

These are Hours and Minutes.

I did use this but it not work.

Time(Alt(Time#(Time,'hmm'),Time#(Time,'hhmm')),'hh:mm')  as  time

It is showing like this.

[PrashantSangle]

Hi,

What do you mean by it not work???

Which value you are getting wrong??

Regards

[#6]

Hi Max,

This values are came correct.

400

450

600

645

730

These are not came correct.

1000

1200

1230

[PrashantSangle]

Hi,

Well then try below

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

It will work for you

Regards

[sunilkumarqv]

Time(Timestamp(

Alt(

  Timestamp#([DateField],'DD/MM/YYYY hh:mm[:ss]'),

  Timestamp#([DateField],'DD-MM-YYYY hh:mm[:ss]')

  )

,'DD/MM/YYYY hh:mm'),'hh:mm') as Time

[#9]

Hi Sunil,

I am getting same problem.

[PrashantSangle]

Hi,

did try my new suggestion.

Regards