Reputation: 1240
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
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