MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date/Time


Posted by Alex Nolan on September 17, 2001 12:22 AM

Hi
I have a problem with a time date format
Im 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 cell
and 09-28-01 09:06:21 in the next
I 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??

Ian