You need to enter it as 0:0:55
--
David Biddulph


Nadine wrote:
Have cells custom formatted for seconds :ss
but in the formala bar shows and invalid date and time, is there a
way to make the formula bar show the correct value of the cell

i.e.
typed in cell - 55 for 55 seconds
but the formula bar showing content as: 1900-02-24 12:00:00 AM
for me to get it to display as :55
have to enter it as :55
but then can't use it for a calculation

if format it as mm:ss
enter 55 shows as 00:00 in the cell
but in the formula bar shows content as: 1900-02-24 12:00:00 AM

need cells to display a seconds :55
but will need to use the cells for other calculations