Posted by Alex Nolan on September 17, 2001 12:22 AM
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!