
Elementary Math Fractions, Percentages, Word Problems, Equations, Inequations, Factorization, Expansion 
 LinkBack  Thread Tools  Display Modes 
June 11th, 2017, 10:20 PM  #1 
Newbie Joined: Jun 2017 From: Brooklyn NY Posts: 1 Thanks: 0  Timecode in seconds math
I have a set of timecode (video) that gets generated by a media player. The timecode is used in a database. For example, the timecode status shows that 3,894 seconds have gone by. Was able to do the math for the Timecode of 01:04:54 to come to that like so... Hours * 60 * 60 = 3600, Minutes * 60 = 240, Seconds = 54... which is Hours + Minutes + Seconds to come to 3,894. My question is how do I go the other way. For example with 3,894 and a number like 7253, how could I end up with 01:04:54 or 02:00:53 respectively? I realize I will have to put back the colons (":"), that I can do. As for the math, I can figure them out, but I would like to know a good method of doing math like this. Also, what would this type of math be called (Algebra, Quadradic...)? Thanks for any help.

June 11th, 2017, 10:46 PM  #2 
Global Moderator Joined: Dec 2006 Posts: 17,706 Thanks: 1356 
You would effectively be converting from base 10 (decimal) to base 60 (sexagesimal). Divide by 3600 to get the number of hours. Dividing the remainder by 60 gives the number of minutes, with the remainder from that division being the number of seconds.

June 25th, 2017, 04:44 AM  #3 
Math Team Joined: Jan 2015 From: Alabama Posts: 2,573 Thanks: 667 
To convert seconds into hours, minutes, and seconds, reverse what you did instead of multiplying by 60, divide. Specifically, 60 divides into 3,894 65 times with remainder 4 so 3,894 seconds is 65 minutes and 4 seconds. 60 divides into 65 once with remainder 5 so 65 minutes is 1 hour and 5 minutes. 3,894 seconds is 1 hour, 5 minutes, 4 seconds. Similarly, 60 divides into 7,253 120 times with remainder 53. That is, 7,253 seconds is 120 minutes and 53 seconds. 60 divides into 120 exactly twice. 120 minutes is 2 hours and no minutes. 7,253 seconds is 2 hours, no minutes, and 53 seconds. 

Tags 
math, seconds, timecode 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
how to read a number into seconds  4matt  Elementary Math  5  July 3rd, 2015 05:33 AM 
yadrs per seconds  guaro555  Math  1  July 8th, 2014 12:49 PM 
Centimetres to Seconds  Freddy  Algebra  7  May 28th, 2011 06:34 PM 
Converting framespersecond into seconds  hedKandiMan  Algebra  2  September 9th, 2008 05:24 AM 