This project has moved and is read-only. For the latest updates, please go here.

hour format

Sep 30, 2014 at 2:33 PM
i have a cell that need to be in format hh:mm,
this is my code
 ws.Cells[rowNumber, 11].Style.Numberformat.Format = "hh:mm";
 string start = row.R_HourStart.ToString("HH:mm");
ws.Cells[rowNumber, 11].LoadFromText(start);
in the excel i see in the cell "10:00" but when i go over it i see in the function field the text "30/09/2014 10:00:00".

i want it to be just "10:00"
Oct 1, 2014 at 7:23 PM
Instead of "hh:mm" try "h:mm", I didn´t find "hh:mm" format in excel built in styles, maybe this is the problem.

http://polymathprogrammer.com/2011/02/15/built-in-styles-for-excel-open-xml/