I want to write a TimeSpan value - 25 hours - to cell as Time format.
If value is less than 24 h than it’s right.
But if value is greater than or equal 24 h than would be 2 problems:
- target cell has string format. for example, 25 h was written as 01:00:00 but as string. (operation SUM or AVERAGE aren’t valid)
- is it possible to display 25 h as 25:00:00? Excel has such format. How to write value correct to get such format?