MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Entering current time in cell with seconds

Posted by Julie Buchanan on November 20, 2001 7:23 AM

I know you can use ctrl + colon in a cell to record the current time, but this rounds down to the minute. Is there a way to have it round & display to the nearest second (or perhaps the nearest 30 second interval)?

Posted by Becky on November 20, 2001 1:17 PM

I don't know if this will help you or not, but if you use the formula =NOW() and change the number format to Time, 1:30:55 PM the time will refresh every time you enter information into any cell.