Author Topic: Time calculations  (Read 1851 times)

niwreg

  • New User

  • Offline
  • *
  • 13
Time calculations
« on: November 28, 2013, 05:46:10 PM »
Hi,

I'm trying to convert a database to radiodj and i get stuck at the duration of a track calculations.

i've got a track from 4:28 (aprox) it shows in the database as duration 267807 i've had an email conversation about this with Marius 2 years ago with stated:

Quote
The calculations are very simple and all are set from the point zero of the track.
You can divide the cue point value from the database to 1000 to obtain the second of the actual cue point.
 
"sta" is the point where the user set the start of the track
"int" is the intro end time
"pin" is the loop in time
"pou" is the loop out time
"xta" is the point where the next track is starting
"end" is the point where the user set the end of the track
"fin" is the fade in duration in milliseconds from the "sta" point
"fou" is the fade in duration in milliseconds that will end on "end" cue point
 
The actual song duration is calculated from "sta" to "end" on the fly, but there is a "duration" field that contains the original song duration.

However when i divide that number with 1000 i can't work it out to represent 4 minutus 28 seconds

How do i calculate that number? I'm working with excel because the other database is in acces so i can map fields with easy. but i got stuk at the calculations of this number.

704djs

  • Hero Member

  • Offline
  • *****
  • 943
  • Personal Text
    704djs We break records like Dj's suppose
    • Hot 107.9 fm
Re: Time calculations
« Reply #1 on: November 28, 2013, 09:45:50 PM »
what r u using to represent the duration mm or ms or sec
Beat 94.7/Hot 107.9  fm banging the hitz that you wanna hear.

niwreg

  • New User

  • Offline
  • *
  • 13
Re: Time calculations
« Reply #2 on: November 29, 2013, 09:57:07 AM »
From jazler i get a number that i can convert to mm:ss.00 using excels built in custom cell view.

If i know how to calculate from there i'm helped a lot.

niwreg

  • New User

  • Offline
  • *
  • 13
Re: Time calculations
« Reply #3 on: December 04, 2013, 12:00:43 PM »
Nevermind i figured it out:

take the value of duration divide it with 86400000 and make excel to show hh:mm,00 and it shows the track length

Farquarh

  • Full Member

  • Offline
  • ***
  • 118
Re: Time calculations
« Reply #4 on: December 04, 2013, 10:06:03 PM »
Could you post the calculation in total? I tried it in excel and it didn't work

niwreg

  • New User

  • Offline
  • *
  • 13
Re: Time calculations
« Reply #5 on: December 06, 2013, 01:25:36 PM »
Take the duration value from jazler and divide it with 86400

convert this cel to display hh:mm,00

From radiodj to display divide the radiodj duration with 86400000 and


convert this cel to display hh:mm,00


convert from Jazler to radiodj

Value from jazler * 1000 and display a . at the 1000