Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've a integer number in seconds: 4.603.422, that I obtain from an expression and i'd like to transfom in: day:hh:mm:ss
I've tried with number format, but result is 00:00:00, then a tried to use functions like time, timestamp, maketime with or without # but i can achieve my target. Is there a function to solve this trouble or have I to calculate dd:hh:mm:ss concatenating different expression to extract separately day, hours and so on?
Who can help me, pls? Tks in advance
Try
=interval(interval#(4603422,'ss'),'d hh:mm:ss')
or
=interval(interval#(FIELDWITHSECONDS,'ss'),'d hh:mm:ss')
Try
=interval(interval#(4603422,'ss'),'d hh:mm:ss')
or
=interval(interval#(FIELDWITHSECONDS,'ss'),'d hh:mm:ss')
I've created a variable with my sum and'ive put it inside expression. Excellent!! Tks
Hi Stefan,this is working perfectly. But, I have customer requirement that, If we download this to excel and select couple if rows, we can only count of the rows but not the sum.
Say I have these values,
03:04:46:45 |
02:22:18:05 |
If we select these, excel should show 05:27:04:50 in the right corner bottom of Excel. Help me out in this.
Thanks