Forum Discussion

sathish_kumar1's avatar
sathish_kumar1
Frequent Visitor
4 years ago
Solved

Whole number to Time Conversion

Hi,

 

I have a column of resolution TAT in hours(which contains more than 24 hours) which is in whole number and I want to convert it into Time Format.

For example, 

col name: Resolution Time(whole number)

234

1

4

56

Coversion I want to do and it should be in Time format

234:00:00

1:00:00

4:00:00

56:00:00

 

Please help and TIA.

 

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi sathish_kumar1 

     

    You can create a new column by concatenating [Resolution Time] column and ":00:00" string. This new column is in the Text data type and Time format. You can use this new column to display and use the original whole number column for calculation. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

2 Replies