Time Number formatting
Posted by Safa Egilmez on June 27, 2001 7:27 AM
I am trying to get Excel 2000 to display and accept military time in my workbook. Everytime I enter "0000" hours, it converts it to "0". I went through all of the formatting options and still does not happen. I then set it as a text option but then when I chart it, the y-axis still does not display the "0000". I an trying to create a daily work schedule and shift coverage by using stacked bars so I do need the military time there. Help!