
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Time field format is 0.00:00:00,
In my import file i have a column for Duration . this is in the format 0.00:00:00, where the first digit is days for events where the duration is more than 24 hours, previously i have removed this in Excel before loading the data but now have a case where events are taking a long time and i need include this.
What should i do to get this included in my duration calculation.
thanks
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe use a format code like
interval(interval#('2.12:23:11','d.hh:mm:ss'))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you expand a bit? what have you removed, just the days bit?
Its hard to advise without knowing exactly what you're trying to do but it is easy enough to add days on to a timestamp etc


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe use a format code like
interval(interval#('2.12:23:11','d.hh:mm:ss'))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Sorry for delay in commenting, it was really that easy 🙂
I had tried DD.hh:mm:ss but i just had to change it it d.hh:mm:ss and it worked..
Thanks
des
