Duration field 1 day = 8 hours

march
Kilo Guru

Hi Community

 

We got the requirement from our Development Team to have new duration field added.

Until there no Problem.

 

The point is that they want 1 day = 8 hours

ie: when a user enter 10 hours, SNOW display that as 1 day and 2 hours.

But also that when we for example do an excel report the exported value of a record with a duration of 1 day and 2 hours is not (24+2)*60*60=93600, but (8+2)*60*60=36000


Is there an existing attribute allowing to control this? Or do we have to play with the stored value using Business Rules?


Thanks

Marc.

11 REPLIES 11

Feiry
Tera Contributor

Hello March,

Did you resolve this issue?

I'm facing the same issue.

Thanks in advance

Feiry
Tera Contributor

Hello March,

Did you resolve this issue?

I'm facing the same problem.

Thanks