

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to convert seconds in to DD:HH:MM:SS format
Hi Folks,
How can we convert seconds in to DD:HH:SS format
for example I am having 20400062 seconds. How can we show this in to Days Hours Minutes seconds format DD:HH:MM:SS
Could you please help on this
Thanks and Regards,
Satya
- « Previous Replies
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like this


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you. But I require in days

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like this;
secondsfeild/360 this will convert hrs
Days conversion:
(secondsfeild/360)/8 as days

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
=Floor(20400062/60/60/24) &' Days ' & Interval(frac(20400062/60/60/24),'hh:mm:ss')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
=Interval([time_field]/86400,'DD:hh:mm:ss')
or
=Interval(20400062/86400,'DD:hh:mm:ss')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
I have used following expression to get DD:HH:MM:ss format
its worked fine
=timestamp(20400062,'DD:HH:MM:ss')
Regards
Sahadev


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much Mahadev
I have a requirement. the above number(20400062) I have shown is in Minutes I want to convert Minutes in to Days. But day have only 8 hours. How can we do this


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much Thakur
I have a requirement. the above number(20400062) I have shown is in Minutes I want to convert Minutes in to Days. But day have only 8 hours. How can we do this


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try Tresco's expression like
just changed 24 to 8 hours.
=Floor(20400062/60/60/8)

- « Previous Replies
- Next Replies »