static time including seconds

G

Guest

This is driving me crazy so please help if you can.

I want to log down time on a machine in our production area into a
spreadsheet using the ctrl+shift+; shortcut. However, a lot of the stoppages
are less than a minute long so I am losing valuable data. Is there any way I
can change the format to include the seconds as well as the minutes and hours
as at the moment it just rounds the seconds to 00.

Thanks so much for your help in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel: How to insert current time (static) to the nearest second? 14
Daily Time Sheets with Rounding 1
sum total of hours minutes seconds in excel 2003 2
calculating time in excel 0
How to enter current static time in Excel in 00:00:00.0 format? 3
Calculating a Target time from an Actual Time... 2
How do I enter accumulated time as hours, minutes and seconds? 1
Date Time increment with additional condition of skipping weekends 13

Top