{"id":2774,"date":"2018-07-03T21:15:48","date_gmt":"2018-07-03T21:15:48","guid":{"rendered":"http:\/\/cocoalopez.com\/blog\/?p=2774"},"modified":"2018-07-03T21:15:48","modified_gmt":"2018-07-03T21:15:48","slug":"convertir-fps-a-timecode-y-timecode-a-fps-en-excel-google-sheets","status":"publish","type":"post","link":"https:\/\/cocoalopez.com\/blog\/?p=2774","title":{"rendered":"Convertir FPS a TIMECODE y TIMECODE a FPS en Excel \/ Google Sheets"},"content":{"rendered":"

This Excel formula grabs a timecode value from cell A1 and converts it into frames. The timecode should be in the format “01:01:01;01”. The formula uses 30 frames per second and does not calculate drop frames.<\/p>\n

=VALUE(LEFT(A1,2))*60*60*30+VALUE(MID(A1,4,2))*60*30+VALUE(MID(A1,7,2))*30+RIGHT(A1,2)\r\n<\/code><\/pre>\n
Example:
\nA1: 01:06:46;11
\nRESULT: 120191<\/p>\n
This Excel formula grabs a number value from cell A2 and converts it into timecode.<\/p>\n
=TEXT(MOD(INT(INT(INT(ABS(A2)\/30)\/60)\/60),60),\"00\")&\":\"&TEXT(MOD(INT(INT(ABS(A2)\/30)\/60),60),\"00\")&\":\"&TEXT(MOD(INT(ABS(A2)\/30),60),\"00\")&\";\"&TEXT(MOD(ABS(A2),30),\"00\")\r\n<\/code><\/pre>\n
Example:
\nA2: 112019
\nRESULT: 01:02:13;29<\/p>\n
You may want to replace “30” in that formula for a more accurate Frames Per Second value (e.g., 29.97 for NTSC, 25 for PAL).<\/p>\n
This Excel formula calculates the difference between two timecode values and outputs “GOOD” if they are within 3 frames of each other. Otherwise, it outputs the actual difference as a timecode.<\/p>\n
=IF((A4-A3)=MEDIAN((A4-A3),-3,3),\"GOOD\",TEXT(MOD(INT(INT(INT(ABS(A4-A3)\/30)\/60)\/60),60),\"00\")&\":\"&TEXT(MOD(INT(INT(ABS(A4-A3)\/30)\/60),60),\"00\")&\":\"&TEXT(MOD(INT(ABS(A4-A3)\/30),60),\"00\")&\";\"&TEXT(MOD(ABS(A4-A3),30),\"00\"))\r\n<\/code><\/pre>\n
You may want to replace the value pair (-3,3) by a named cell containing a user determined error allowance. That way the formula will mark errors that fall withing the allowed interval as correct.<\/p>\n
Example:
\nA3: 01:13:35;05
\nA4: 01:13:35;04
\nRESULT: GOOD<\/p>\n
A3: 01:15:31;13
\nA4: 01:15:30;12
\nRESULT: 00:00:01;01<\/p>\n
NOTE:
\nThe formula “IF((A4-A3)=MEDIAN((A4-A3),-3,3)” calculates whether the value of A4-A3 falls within the values -3 and 3. If you were trying to determine whether these two values are 1 second apart, you would use -33 and 33 as your boundaries (30 frames equal 1 second).<\/p>\n
This Excel formula will convert frames back into TimeCode. It will add 1 second to the final value, because Hulu requests that we give them the frame-accurate value of the middle of the commercial break.<\/p>\n
=TEXT(MOD(INT(INT(INT(ABS(C3)\/RFPS)\/60)\/60),60),\"00\")&\":\"&TEXT(MOD(INT(INT(ABS(C3)\/RFPS)\/60),60),\"00\")&\":\"&TEXT((MOD(INT(ABS(C3)\/RFPS),60)+1),\"00\")&\";\"&TEXT(MOD(ABS(C3),RFPS),\"00\")  \r\n<\/code><\/pre>\n
This Excel formula will convert frames back into TimeCode. It will round up the seconds and zero out the frames, because YouTube only works with second-accurate commercial breaks. Since our commercial breaks last one second, we can guarantee we fall within the break by rounding up the seconds.<\/p>\n
=TEXT(MOD(INT(INT(INT(ABS(C4)\/RFPS)\/60)\/60),60),\"00\")&\":\"&TEXT(MOD(INT(INT(ABS(C4)\/RFPS)\/60),60),\"00\")&\":\"&TEXT((MOD(INT(ABS(C4)\/RFPS),60)+1),\"00\")&\";\"&\"00\"\r\n<\/code><\/pre>\n
RFPS in the formulas is a named cell containing the real FPS value.<\/p>\n
Fuente: https:\/\/github.com\/cgranier\/Excel-Timecode<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
This Excel formula grabs a timecode value from cell A1 and converts it into frames. The timecode should be in the format “01:01:01;01”. The formula uses 30 frames per second and does not calculate drop frames. =VALUE(LEFT(A1,2))*60*60*30+VALUE(MID(A1,4,2))*60*30+VALUE(MID(A1,7,2))*30+RIGHT(A1,2) Example: A1: 01:06:46;11 RESULT: 120191 This Excel formula grabs a number value from cell A2 and converts it […]<\/p>\n","protected":false},"author":1,"featured_media":2776,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1002],"tags":[],"class_list":["post-2774","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/07\/convertir-fps-a-timecode-y-timecode-a-fps-en-excel-google-sheets.jpg?fit=462%2C467&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9XJix-IK","jetpack-related-posts":[{"id":2777,"url":"https:\/\/cocoalopez.com\/blog\/?p=2777","url_meta":{"origin":2774,"position":0},"title":"HOW TO CONVERT KEYFRAME BMK TO EDL","author":"cgmodeler","date":"July 4, 2018","format":false,"excerpt":"This is to import a bmk file from KeyframeMp to Premiere as EDL Converted Frame bookmarks to start and end ranges Converted Frame numbers to timecode Adapted to EDL timecode format Outline: Save BMK Edit it in Notepad, leave only frames and remove comma, adding paragraph between frames Import csv\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/07\/how-to-convert-keyframe-bmk-to-edl.png?fit=352%2C494&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":4600,"url":"https:\/\/cocoalopez.com\/blog\/?p=4600","url_meta":{"origin":2774,"position":1},"title":"Helldivers PS4 Save Editing Guide: Key Variables & Apollo Process","author":"cgmodeler","date":"November 1, 2025","format":false,"excerpt":"So I've spend about 5 hours but finally nailed it. Got how to edit the save file and make it work for Helldivers PS4 version. Feel free to buy me a coffe https:\/\/ko-fi.com\/cocoalopez This short guide covers editing common stats in Helldivers 1 PS4 save files using a hex editor\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2025\/11\/Helldivers_art.jpg?fit=315%2C315&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3754,"url":"https:\/\/cocoalopez.com\/blog\/?p=3754","url_meta":{"origin":2774,"position":2},"title":"FAKE SSS for 3DS MAX Viewport","author":"cgmodeler","date":"October 9, 2022","format":false,"excerpt":"https:\/\/vimeo.com\/41147048 Code over here: http:\/\/www.aardolino.com\/blog\/ or Playing Remedy\u2019s Alan Wake for Xbox, and feeling lost seeing its marvelous forest environment, wondering about how to procedurally animate trees and vegetation using vertex colors, the idea of SS&F-SSS came out: use mesh thickness to modulate a SSS color. [Yes\u2026it\u2019s not related to\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/10\/imagen-7.png?fit=1016%2C784&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/10\/imagen-7.png?fit=1016%2C784&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/10\/imagen-7.png?fit=1016%2C784&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/10\/imagen-7.png?fit=1016%2C784&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3642,"url":"https:\/\/cocoalopez.com\/blog\/?p=3642","url_meta":{"origin":2774,"position":3},"title":"Collection of FFMPEG Drag & Drop CMD\/BAT Tools","author":"cgmodeler","date":"July 2, 2022","format":false,"excerpt":"Here's a small collection of scripts i've made, downloaded, modified, etc to compress, edit, add, remux video files as well as converting mkv files without the need of re-rendering. Copy the code and save as a .bat file, save it on your ffmpeg bin folder or any command line if\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"close up photo of programming of codes","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/07\/pexels-photo-546819.jpeg?fit=1200%2C797&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/07\/pexels-photo-546819.jpeg?fit=1200%2C797&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/07\/pexels-photo-546819.jpeg?fit=1200%2C797&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/07\/pexels-photo-546819.jpeg?fit=1200%2C797&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/07\/pexels-photo-546819.jpeg?fit=1200%2C797&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3849,"url":"https:\/\/cocoalopez.com\/blog\/?p=3849","url_meta":{"origin":2774,"position":4},"title":"Telegram Bot to notify your channel when a Google Sheet Cell has been edited","author":"cgmodeler","date":"December 22, 2022","format":false,"excerpt":"Did this one over an hour to notify me when certain cells change their value and their adjacent values. Change your telegram bot token and Channel ID to make it work. On the google sheets you want to edit add the following code and add a trigger for it that\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/image-4.png?fit=1049%2C318&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3685,"url":"https:\/\/cocoalopez.com\/blog\/?p=3685","url_meta":{"origin":2774,"position":5},"title":"UI and Viewport performance lags or seems slow on fast multicore CPUs in 3ds Max","author":"cgmodeler","date":"September 21, 2022","format":false,"excerpt":"Found this thread for solving the sluggish UI on 3DS MAX. https:\/\/knowledge.autodesk.com\/support\/3ds-max\/troubleshooting\/caas\/sfdcarticles\/sfdcarticles\/3ds-Max-UI-lags-or-seems-sluggish-even-on-very-fast-multi-core-CPUs.html Issue: 3ds Max lags or shows a delay in performance, even on fast CPUs. This includes, but is not limited to Intel i9 and AMD 'Ryzen Threadrippers'.This includes clicking any area of the user interface or moving objects,\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/09\/imagen-3.png?fit=872%2C829&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/09\/imagen-3.png?fit=872%2C829&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/09\/imagen-3.png?fit=872%2C829&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/09\/imagen-3.png?fit=872%2C829&ssl=1&resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2774"}],"version-history":[{"count":1,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2774\/revisions"}],"predecessor-version":[{"id":2775,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2774\/revisions\/2775"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/2776"}],"wp:attachment":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}