or perhaps format as minutes and seconds
[m]:ss
instead of formatting in seconds
Many Date an Time questions would be answered in either of our
webpages.
http://www.mvps.org/dmcritchie/excel/datetime.htm more than just Excel
http://www.cpearson.com/excel/datetime.htm shorter
ExcelForum had made searching for web pages very difficult because
they put newsgroup postings onto web pages where they get indexed
again by Google (in addition to being indexed by Google Groups).
Unless Google stops indexing such pages as websites the problem will
continue to grow, and Google has their own answers.google.com so
that is not likely to happen. Newsgroups have lots of questions that
are asked and answered 100s of times; whereas, web pages written
on a topic tend to be better written and less redundant. If you could
eliminate the newsgroup type of postings you would see Chip's web page
near the top of a web search for -- excel difference in time
Just the same almost every answer posted has been posted before or
is based on previously posted questions and answers, or directly from
the Excel Help, or Microsoft KB. So while the answers may get better
with time, a lot of effort is wasted on duplication.
newsgroups searches.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm