R
rino13
I am using the Medis player to Excel converter! Problem, the duration in time
for my media (songs) is way off base. For the lenth of the song, I'm showing
458.77 as the lenth of the song. The only way I can make any sense of this is
to divide (a1/24/60) which leaves me with 0.31859! When I change it to the
(h)mm:ss format, I get 7:38:46, which is 7-HOURS : 38-MINUTES : 46 SECONDS of
some date that is now hidden! IS there an easy fix, or formula that can be
used for duration?
for my media (songs) is way off base. For the lenth of the song, I'm showing
458.77 as the lenth of the song. The only way I can make any sense of this is
to divide (a1/24/60) which leaves me with 0.31859! When I change it to the
(h)mm:ss format, I get 7:38:46, which is 7-HOURS : 38-MINUTES : 46 SECONDS of
some date that is now hidden! IS there an easy fix, or formula that can be
used for duration?