Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Nidhi_Nagesha
Contributor

Combine hours, minutes and seconds

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.

Labels (1)
1 Reply
mikaelsc
Specialist

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