Time field format is 0.00:00:00,

[Anonymous]

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

[adamdavi3s]

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

[swuehl · Accepted solution]

Maybe use a format code like

interval(interval#('2.12:23:11','d.hh:mm:ss'))

[Anonymous]

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