Combine hours, minutes and seconds

[Nidhi_Nagesha]

Hi,

I have a data set where hours, minutes and seconds have been listed in 3 different columns. I want to combine them and show them in 1 field as hh:mm:ss.

Hours	Minutes	Seconds
19	30	15

Need it to look like 19:30:15

Would be great if I got some help with this.

[mikaelsc]

define a new field (better in script) using the expression maketime(Hours,Minutes,Seconds) as Time

if you also have a date timestamp(makedate(Year,Month,Day)+maketime(Hours,Minutes,Seconds)) as Timestamp