Time Formatting on a create time field

[#1]

Hi guys

Please find the attached and Advice on how i can get this right

E.G .. 253 is suppose to be 00:02:53

          20904 is suppose to be 02:09:04

Thank you very much

[sunny_talwar · Accepted solution]

Try this:

=Interval(Interval#(Num(253, '000000'), 'hhmmss'), 'hh:mm:ss')

=Interval(Interval#(Num(20904, '000000'), 'hhmmss'), 'hh:mm:ss')

[Chanty4u]

chk ds

=interval(urfield,'hhmmss')

Timestamp

Date & Time format

[#4]

Sunny You are the best , it work fine .

Thank You very Much .