Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert from decimal to duration (HH:MM:SS)

How can I convert decimal to duration format?   response time target response time 00:30:00 2,50 01:00:00 0,433 02:00:00 1,133   I want to convert the column "target response t...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    duration = [target response time] / 24

    cast the calculated column to type "Time"

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Can you let me know whether this answer worked for you or not please?

If it worked ok, please mark as the solution to help people with similar problems find the answer quicker.

 

Best Regards,
Eyelyn Qin