I am trying to export data to excel file using c sharp codes. The data is a 'duration' which is required in the format of HH:mm:ss , but when it is exported to excel, it will appear with the 'AM/PM' and in 12 hour format automatically. For example. if the real data is 16:00:00 (16 hours 0 minutes n 0 seconds) , it will appear as '04:00:00 PM' in the cell of the excel file. Help?
No comments:
Post a Comment