J
jmanlasman
How would I change the format of a standard time like 1:31 (1 minute
31 seconds) to a DV timecode format of 00:01:31:00 easily?
Thanks
31 seconds) to a DV timecode format of 00:01:31:00 easily?
Thanks
Sorry, I slipped this one (I use different formatting), the correct formula
should be:
=SUBSTITUTE(TEXT(A1,"hh:mm:ss.00"),".",":")
Voilà, that's it...
Sorry, I slipped this one (I use different formatting), the correct
formula
should be:
=SUBSTITUTE(TEXT(A1,"hh:mm:ss.00"),".",":")
Voilà, that's it...
Hi Jeremy,
The easiest would be probably to insert a column next to the one holding
your data (let's say column B) and use the formula in there. Replicating it
downwards should work.
Kind regards,
Erny
Thank you very much for your help! You dont know how much time you are
saving me. One quick last question though. Lets say I have the numbers
entered in minutes from A1 to A10 and I wanted to use this formula to
quickly do them all, how would I change the thing you gave me? I tried
A1:A10 and the substitute formula, but that still only did A1.
Thank you again for your solution!
-Jeremy
Hi Jeremy,
The easiest would be probably to insert a column next to the one holding
your data (let's say column B) and use the formula in there. Replicating it
downwards should work.
Kind regards,
Erny
Thank you very much for your help! You dont know how much time you are
saving me. One quick last question though. Lets say I have the numbers
entered in minutes from A1 to A10 and I wanted to use this formula to
quickly do them all, how would I change the thing you gave me? I tried
A1:A10 and the substitute formula, but that still only did A1.
Thank you again for your solution!
-Jeremy
Hi Jeremy,
The easiest would be probably to insert a column next to the one holding
your data (let's say column B) and use the formula in there. Replicating it
downwards should work.
Kind regards,
Erny
Thank you very much for your help! You dont know how much time you are
saving me. One quick last question though. Lets say I have the numbers
entered in minutes from A1 to A10 and I wanted to use this formula to
quickly do them all, how would I change the thing you gave me? I tried
A1:A10 and the substitute formula, but that still only did A1.
Thank you again for your solution!
-Jeremy
Hi Jeremy,
The easiest would be probably to insert a column next to the one holding
your data (let's say column B) and use the formula in there. Replicating it
downwards should work.
Kind regards,
Erny
Thank you very much for your help! You dont know how much time you are
saving me. One quick last question though. Lets say I have the numbers
entered in minutes from A1 to A10 and I wanted to use this formula to
quickly do them all, how would I change the thing you gave me? I tried
A1:A10 and the substitute formula, but that still only did A1.
Thank you again for your solution!
-Jeremy
Hi Jeremy,
The easiest would be probably to insert a column next to the one holding
your data (let's say column B) and use the formula in there. Replicating it
downwards should work.
Kind regards,
Erny
Thank you very much for your help! You dont know how much time you are
saving me. One quick last question though. Lets say I have the numbers
entered in minutes from A1 to A10 and I wanted to use this formula to
quickly do them all, how would I change the thing you gave me? I tried
A1:A10 and the substitute formula, but that still only did A1.
Thank you again for your solution!
-Jeremy
I've ran into another problem. Since this is a DV tape, the time goes
from 0:00 - 1:00:00. I have for example 28:48 (28 minutes 48 seconds)
and it is being converted by excel to 00:04:48:00 because 24 hours in
a day. How would I fix this?
Thanks for your help,
Jeremy
Hi Jeremy,
The easiest would be probably to insert a column next to the one holding
your data (let's say column B) and use the formula in there. Replicating
it
downwards should work.
Kind regards,
Erny
Newsbeitrag
Thank you very much for your help! You dont know how much time you are
saving me. One quick last question though. Lets say I have the numbers
entered in minutes from A1 to A10 and I wanted to use this formula to
quickly do them all, how would I change the thing you gave me? I tried
A1:A10 and the substitute formula, but that still only did A1.
Thank you again for your solution!
-Jeremy
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.