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] + .
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.