entering timecode into cells

[Laura]

I'm trying to enter metadata for video assets. When I enter "35:55" for 35
minutes and 55 seconds, it keeps being changed to a fraction or a date or
sometimes "0:35:55". I've tried formatting the cells to general or MM:SS, but
it won't work

Does anyone know what to select when entering TRTs for tapes?

Thanks!

 

[Gary''s Student]

Format > Cells... . Number > Custom > mm:ss
and then enter the full time:
00:35:55
to display:
35:55

 

[Laura]

Ah-ha! Worked like a charm. Thanks!

Format > Cells... . Number > Custom > mm:ss
and then enter the full time:
00:35:55
to display:
35:55