Displaying 00:00:00

Occasional Visitor

I am having trouble getting excel to display 00:00:00 in a cell, i am using a rota sheet as a look up, the calculation for shift worked is correct but the cell is empty 


1 Reply


Format numbers as dates or times


When formatting [hh]:mm, you can also enter 24:00.

since both times represent the same value, namely midnight, it was decided at that time to use 00:00 for midnight.


Show time 24:00 instead of 0:00.


Call up the "Format Cells" dialog

with the key combination [Ctrl] +[1] .


Numbers --> Custom --> Type: Enter [hh]:mm instead of hh:mm


The square brackets are the difference!

The placeholder [hh] ensures that hours over 24 are displayed.


I would be happy to know if I could help.



Was the answer useful? Mark them as helpful!

This will help all forum participants.