Kevin
Kevin

Reputation: 1240

C# TimeSpan Not Displaying Days

I am writing an app that uses the TimeSpan object. Specifically I am using the constructor TimeSpan(int32, int32, int32, int32). However, when I output my results to an Excel file the TimeSpans display in the format hh:mm:ss where I was expecting dd:hh:mm:ss. With the data I have right now all of the days are 0 -- but then I was expecting 00:hh:mm:ss instead of the shorter format.

Any advice is appreciated.

Upvotes: 1

Views: 250

Answers (1)

HasaniH
HasaniH

Reputation: 8402

You need to set the formatting of the cells in Excel to the format you want. It probably set the formatting automatically because all the day values are 0

Upvotes: 1

Related Questions