I can't seem to get the cells formatted to give me minutes and seconds of a video clip and then add them consecutively on the right column to show a total for the entire show. Anyone with suggestions?
There are numerous examples of this if you do a search of past
postings. Basically although you display a time excel records this as
fractions of a day. e.g. enter 3:30 am and Excel interprets that to
3.5 as a fraction of 24 i.e. 0.145833.
When you total these I suspect you are coming up with odd results
because you need to make the answer formatted something like
[hh]:mm:ss
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.
