This project has moved. For the latest updates, please go here.

DateTime formatting

Mar 23, 2016 at 2:30 PM
How can I get a date column to show date and time?

wb.Worksheets.FirstOrDefault().Column("B").Style.DateFormat.SetFormat("mm/dd/yyyy h:mm");

This format is working only for the date, but for the time it is always showing military time instead of 1-12 for the hours. I also want it to show PM or AM.

What am I doing wrong?