Forum Discussion
Displaying 00:00:00
Hi, 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
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.