How to add a time duration format

How to add a time duration format

Posted by: adisa.craig on 15 August 2022, 2:29 pm EST

• 

  adisa.craig

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 15 August 2022, 2:29 pm EST

  Hi I am looking to add a duration format for example if something takes more than a day to complete but is displayed in hours minutes and seconds as 26:00:00 spread automatically converts it to 2:00:00, as it is using a 24hours format, is there a way to prevent this conversion and keep the duration instead

• 

  william.chang

  • Post Options:
  • Link
    Copy

  Posted 17 August 2022, 3:21 am EST

  Hi Adisa,
  
  Try using the ```
  
  [h]:mm:ss;@

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 17 August 2022, 4:55 am EST

  Hi Adisa,

  Please try with the William’s solution and let us know if you face any issues. I tested it at my end it just works fine.

  Regards
  
  Ankit