Time format
 

Hi!

I´m trying to add and record different operation times ranging from several
hours to seconds, when I try to enter these into excel using the format
hh:mm:ss and for example enter 93:36:00 (which is the stop time for a
specifik machine during a certain period of time) excel changes this to
1900:01:03 21:36:00 which is 93 hours and 36 minutes after new years eve
1900. But since I REALLY dont care about anything in 1900, this is quite
irritating.

How can I enter times expressed in hours, minutes and second without getting
these turned into dates???

Pete

Time format
 

Custom format the cell to (Right clickFormatCellsCustomType)
[h]:mm:ss

Still in formula bar it will be displayed as 1/3/1900 9:36:00 PM since. But
this will not affect any calculations... For more information on how excel
handle date/time refer the below link.
http://www.cpearson.com/excel/datetime.htm

If this post helps click Yes
---------------
Jacob Skaria


"Pete" wrote:

Hi!

I´m trying to add and record different operation times ranging from several
hours to seconds, when I try to enter these into excel using the format
hh:mm:ss and for example enter 93:36:00 (which is the stop time for a
specifik machine during a certain period of time) excel changes this to
1900:01:03 21:36:00 which is 93 hours and 36 minutes after new years eve
1900. But since I REALLY dont care about anything in 1900, this is quite
irritating.

How can I enter times expressed in hours, minutes and second without getting
these turned into dates???

Pete

Time format
 

Format as [hh]:mm:ss
--
David Biddulph

"Pete" wrote in message
...
Hi!

I´m trying to add and record different operation times ranging from
several
hours to seconds, when I try to enter these into excel using the format
hh:mm:ss and for example enter 93:36:00 (which is the stop time for a
specifik machine during a certain period of time) excel changes this to
1900:01:03 21:36:00 which is 93 hours and 36 minutes after new years eve
1900. But since I REALLY dont care about anything in 1900, this is quite
irritating.

How can I enter times expressed in hours, minutes and second without
getting
these turned into dates???

Pete