| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
