- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Convert decimal value of seconds into days, hours, minutes, seconds
Hi there,
Been searching online but it only shows how to format text and I want to show a time value if possible.
I have numerical values ranging from 458600 to 6 > which are the number of seconds between a start date/time and an end date/time.
I want to show this decimal as dd:hh:mm:ss or similar.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Create a column as given below:
Column= SecondsColumn/86400.
Later select the Column and goto Modelling and change the DataType and Format as given below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@hthota thanks for this, I have tested it and at first it looked perfect but values where the time is over 24 hours e.g. 155284 seconds - is being converted to 19:08:04 when it should be 43:08:04.
Is there an IF statement I should include for higher values?
🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Actually @hthota I understand why it doesn't like values over 24hrs - because i've converted it to a time, it turns 24 back into zero. This is ok, because I can filter our these values from any measures as my dataset is in QA and when we move to production we won't have call durations over a day!
Thanks once again.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-31-2024 10:11 PM | |||
03-04-2024 06:33 AM | |||
08-26-2024 09:19 PM | |||
02-20-2023 12:32 AM | |||
09-29-2017 12:38 PM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |