Number to timestamp

[#1]

hi,

Which function in QV can I use to convert a number eg 54620 to hh:mm:ss?

Regards,

Kevin

[ashfaq_haseeb · Accepted solution]

Hi,

what is your expected output here.

Try like below

=interval(timestamp#(54620, 's'), 'hh:mm:ss')  --> 15:10:20

Or

=Time#(Left(Repeat('0',6-Len(54620))&54620,2) & ':' & Mid(Repeat('0',6-Len(54620))&54620,3,2)& ':' &Right(Repeat('0',6-Len(54620))&54620,2),'hh:mm:ss')   --> Returns 05:46:20

Regards

ASHFAQ

[amit_saini]

Kevin,

Like this????

=Time(Time#('9690','ss'),'hh:mm:ss') ---------2:41:30 (Output)

Thanks,

AS

[PrashantSangle]

Hi,

Use like

Time(54620,'hh:mm:ss')

Regards

[MarcoWedel]

Hi,

maybe like this?:

hope this helps

regards

Marco

[manideep78]

Like this

=TimeStamp(Timestamp#('54620','hmmss'),'hh:mm:ss')

[jagan]

Hi Kevin,

Try like this

If time is in hmmss format

TimeStamp(Timestamp#('54620','hmmss'),'hh:mm:ss')

If 54620 is seconds then try like this

=interval(timestamp#(54620, 's'), 'hh:mm:ss')  --> 15:10:20

Regards,

Jagan.

[#8]

works! cheers

[#9]

works! cheers!

[#10]

didn't return the correct timestamp, cheers though.