24 hour = 0:00 format doesnt show in excel - Microsoft Community

i have problem trying 'show' 24 hour time.

each time type in 0:00, shows blank cell, although know hidden in there because calculation correct.

ive tried format cell 'automatic' colour , 'black' colour, no avail.

please help

example below

time =                                                                                                                                            

5:30

6:30

21:00

22:00

23:00

4.00

                                                                                                                                                                ^
                                                                                                                                                        total hours

click office button in upper left corner, click excel options near bottom.

click advanced in navigation pane on left hand side.

scroll down section 'display options worksheet'.

make sure check box 'show a 0 in cells have 0 value' ticked.

click ok.

Office / Excel / Windows other / Office 2007