Duration type field population through transform map

[Shubham Bongulw]

Hi Community,

In my load data I have duration mentioned in hours for e.g. '7','3' etc.

In my target table, the field is of type duration and is shown as below-

The data that is in load data is getting populated in seconds field of duration. Is there anyway that i can populate this in hours field?

[Ankur Bawiskar]

@Shubham Bongulw 

what does 7",3 mean?

can you share how it looks in excel or import set field?

[Shubham Bongulw]

Hey Ankur,

I mean just a single digit like '7',etc. That means 7 hours. While importing it is going into seconds field.

[Shubham Bongulw]

Also they have provided values like - 1.5 hrs, 0.25hrs. How can i map these?

[Ankur Bawiskar]

@Shubham Bongulw 

check these links

Import data into Duration type field 

How To Master The ServiceNow Duration Field