Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JE McGimpsey
 
Posts: n/a
Default

See this thread

http://groups-beta.google.com/group/...misc/browse_fr
m/thread/914f04f30fb89014/a19e78dc6a488943

In article ,
"Kaedo" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing Time Pete Excel Discussion (Misc queries) 3 February 8th 05 12:52 PM
mulitiplying time Brad Excel Worksheet Functions 1 February 1st 05 07:15 PM
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 09:15 PM
The shortcut to enter time in excel should include seconds. JoeGill Excel Discussion (Misc queries) 3 January 9th 05 08:02 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 03:24 PM


All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"