I am trying to use Excel to enter my IN and OUT timecode information. I am having trouble getting my format to appear correctly. My timecode is based on 60 frame/sec so it may look like 00:04:34.51 but freakin' Excel will change it to 04:34.50, truncating the hour 00 and rounding down the frame number. I have tried setting the column cell type to Number, Text and custom (which I don't understand well) with no luck.
I did search for Excel macros for timecoding info and most are based on 24 or 29 frame/sec. It would be a bonus to have a timecode macro that can calculate the elapsed time between IN and OUT but that is not essential.
My main issue is getting the formatting right because I am copying and pasting from a word doc with the original timecode format.
Right now I have to copy from my word doc, paste into notepad, then copy from notepad and paste into Excel for the format to appear correctly. Talk about a productivity nightmare.