Featured Product

Excel Daily News

Search MrExcel

Date/Time

HiI have a problem with a time date formatIm setting up a simple scoring sheet for races which may start on one day and finish on the next.

I can get it working in the format dd/mm/yy hh:mm:ss but the seconds arnt displayed in the cell. I have a start time cell, and a finished time cell from here I can convert it in to the hh:mm:ss elapsed time format requiredeasily enough. But I still need the seconds displayed in the finish and start time cells.

So if anyone has any clues or suggestions or easier ways of tackling the problem let me know!

Thanks!

Posted by Ian on September 17, 2001 1:14 AM

Can't see waht your doing wrong

I put 09-27-01 12:03:23 in one celland 09-28-01 09:06:21 in the nextI formatted the cells to dd/mm/yy hh:mm:ss and in the third cell I put the second minus the first and ended up with seconds in all three??

(12 responses) HI! I am using a vlookup/match to populate fields from column headers. For the most part it's doing exactly what I need except instead of pu

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View our Privacy Policy, Cookies Policy, and Terms of Use.