cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
heytherejem Member
Member

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
hthota Member
Member

Re: Convert decimal value of seconds into days, hours, minutes, seconds

SampleSecondtoTime.PNG

4 REPLIES 4
hthota Member
Member

Re: Convert decimal value of seconds into days, hours, minutes, seconds

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.

 SecondstoTime.PNG

 

hthota Member
Member

Re: Convert decimal value of seconds into days, hours, minutes, seconds

SampleSecondtoTime.PNG

heytherejem Member
Member

Re: Convert decimal value of seconds into days, hours, minutes, seconds

@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? 

 

:-) 

heytherejem Member
Member

Re: Convert decimal value of seconds into days, hours, minutes, seconds

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.