
Contributor
2022-06-22
01:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
428 Views
1 Reply


Specialist
2022-06-22
02:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
420 Views
