Does anyone have a formula for SMPTE timecode in Excel?

G

Guest

I'm working with timecode and all of the functions in Excel seem to only work
in reference to clock time. I only need minutes and seconds, but I can't
enter these in without it being read as an hour and minute clock time (ex:
24:40 = 12:40:00 AM) unless I enter it with zeros first, but then it still
reads a clock time (ex: 00:24:40 = 12:24:40 AM). Does anyone have a solution
here?
 
B

Bernie Deitrick

Enter with the leading zeros, but format the cell for custom

[m]:ss

The formula bar will still show "12:24:40 AM" but the cell will show 24:40
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advance Filter Formula 2
Excel Timesheet Error 2
Timecode in Excel 2
Formula Bar - display of content 4
How do I enter time (12-hour clock) & have it display it? 3
autofill date times 4
can Excel really deal with elapsed time? 1
How to count the time slot? 4

Top