Main question:
Is there any way to change a cell so that it displays “24:00:00” as “24:00:00”? I’m using mobile.
Elaboration:
I currently have data that is “24:00:00”. There are some cells in my spreadsheet that stubbornly display this as “00:00:00” even though, if you click on the cell, you could see that the data underneath it is actually “24:00:00”.
Hii @A1391 i see the problem in Calc.
Is there any way to change a cell so that it displays “24:00:00” as “24:00:00”?
The cell value that shows 00:00:00 is correct and logical because in 24 hr format there is no such value like 24:00:00 should be displayed as it is out the 24-hour bound range 
I currently have data that is “24:00:00”. There are some cells in my spreadsheet that stubbornly display this as “00:00:00” even though, if you click on the cell, you could see that the data underneath it is actually “24:00:00”.
Oh, this is not OK . This is a bug, thanks for the attention. Can you please help me to report this to our GH issues section. ?
It would be very helpful if you could add some description and screen recording/ snapshots in GH.
Also, this bug seems very interesting to fix, and we would love if you want to contribute :). Lee me know i will help you with code pointers and further any guidance.
Thanks,
Darshan