I work with a video coding program, and I exported the coding as an excel spreadsheet.
I have start and end times that show up as hh:mm:ss:ms (milliseconds).
I need to calculate the difference between start and end times, but the formula won't work because I can't get excel to recognize the values as times/numbers.
Help?
*Also working with a mac.
There can be a number of causes fort this. Can you attach a sample sheet showing the problem?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Seems to be millisecond info here, but read the part about accuracy.
http://www.pcreview.co.uk/threads/ti...conds.3759609/
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I tried doing a custom format in the form hh:mm:ss.000 but it doesn't change anything.
Try this - you have text that just looks like a number. This will give you a value (in seconds) that you can then use:
=(3600*LEFT(A3,2)+60*MID(A3,4,2)+--MID(A3,7,2)+MID(A3,10,2)/100)
Thanks!
I definitely got a number using that formula, and was able to subtract the end time from the start time, but now how do I get that number back to something that makes sense?
Not sure what you mean by that. See file for the formula in context. Doesn't this do what you'd wanted??
I had the cell with the formula formatted as time, my bad.
This works, thank you so much!
No problem... snd thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks