-
Paper edit for client comments HH:MM:SS autoformatted
Hello guys, long time no see!
I have partially made a spreadsheet that clients can use to easily input timecodes and comment on an edit I’ve sent them.
It formats with colons automatically, which is nice, does HH:MM:SS only (my clients dont have the ability to navigate by the frame, and in any case, that would be my job!)
Problem is, this works as a Google Doc, but I cannot get it to work on Excel.
Can any of you boffins (Pat McGowan, where are you?) try create it?The other bells and whistles thing which is way more complex is for it to also calculate duration, but that becomes a whole LOT more complex with framerates etc… so could also be done with just HH:MM:SS too.
The Google Docs one is at:
https://docs.google.com/spreadsheets/d/1mS9hRbgOboiwTTW-fjo3exXosH7Gr5s7aMHS9di2bYg/edit?usp=sharingPlease make a copy in your google drive.
Thanks,
Mark. -
7 Replies
-
Excel doesn’t understand the number formatting that Google uses.
Try
00\:00\:00
in Excel
Asus P6X58D Premium * Core i7 950 * 24GB RAM * nVidia GeForce GTX 770 * Windows 7 Premium 64bit * System Drive – WD Caviar Black 500GB * 2nd Drive(Pagefile, Previews) – WD Velociraptor 10K drive 600GB * Media Drive – 2TB RAID0 (4 – WD Caviar Black 500GB drive) * Matrox MX02 Mini * Adobe CC * QuickTime 7.7.5
——————————————-
“98% of all computer issues can be solved by simply pressing ‘F1’.”
Steve Brame
creative illusions Productions -
-
Didn’t realize that you wanted to perform calculations – your sample file didn’t include any. If you need to calculate timecodes, my previous example won’t work, so ignore it.
Asus P6X58D Premium * Core i7 950 * 24GB RAM * nVidia GeForce GTX 770 * Windows 7 Premium 64bit * System Drive – WD Caviar Black 500GB * 2nd Drive(Pagefile, Previews) – WD Velociraptor 10K drive 600GB * Media Drive – 2TB RAID0 (4 – WD Caviar Black 500GB drive) * Matrox MX02 Mini * Adobe CC * QuickTime 7.7.5
——————————————-
“98% of all computer issues can be solved by simply pressing ‘F1’.”
Steve Brame
creative illusions Productions -
Hi,
I saw that early on in my explorations, but both the dos and osx versions do not open on my pc, despite saying OK to macros…tx
-
Hi Steve,
Well, the calculations are not imperative.
The client is only going to enter hours minutes seconds… so they can ballpark the durations manually if they like.
The main thing is to have the excel fields automatically change 6 numbers into HH:MM:SS automatically.
I tried that formula and entered it onto excel and it says “Microsoft Excel cannot use the number format you typed. Try using one of the built in number formats.”
Presumably Im using the formula properly, ie entering it in the Format Cells > Custom field?
Tx
Mark. -
It works beautifully here. Here’s a screen shot…
Here are two versions of the Excel file in a DropBox –
https://www.dropbox.com/s/an1q3knr7x1p78k/Excel.xlsx?dl=0
https://www.dropbox.com/s/gdw7vkrywa0v0c4/Excel%2097-2003.xls?dl=0
Asus P6X58D Premium * Core i7 950 * 24GB RAM * nVidia GeForce GTX 770 * Windows 7 Premium 64bit * System Drive – WD Caviar Black 500GB * 2nd Drive(Pagefile, Previews) – WD Velociraptor 10K drive 600GB * Media Drive – 2TB RAID0 (4 – WD Caviar Black 500GB drive) * Matrox MX02 Mini * Adobe CC * QuickTime 7.7.5
——————————————-
“98% of all computer issues can be solved by simply pressing ‘F1’.”
Steve Brame
creative illusions Productions -
Brilliant Steve, works perfectly!
Thank you!That is all I need really, calculations for duration is pretty hard, though this one created by someone else works fine (tested with PAL) but the formatting of timecode numbers is not automatic, and also it HAS to have frames too, otherwise you get some error… but for your interest, here it is:
https://f1.creativecow.net/8454/timecodetx
Mark.
Reply to this Discussion! Login or Sign Up