View Single Post
  #1   Report Post  
taverett
 
Posts: n/a
Default Does anyone have a formula for SMPTE timecode in Excel?

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?