Displaying 00:00:00

[genmike]

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 

[#2]

@genmike 

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.

NikolinoDE

Was the answer useful? Mark them as helpful!

This will help all forum participants.