Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time format
i've got a couple of questions. i trying to build a timing sheet in excel to
track multiple race cars over multiple laps. I've got all the formulas figured out, but my problem is with data entry. there is a standard short cut to enter the current time (shift, ctrl, ;), but when i use this, it doesn't enter the seconds. I've formatted the cell as HH:mm:ss. any ideas here?? also, i know you can format the cells to auto fill, where i could type "345" and it will automatically change it to "$3.45". i've tried to use this with the above time format, but it changes it to a date and time default. it will only recognizes the decimal equivalent of time, whereas 093344 is converted to 07/25/2155 12:00 AM instead of 09:33:44 (hh:mm:ss). any help here would be greatly appreciated. thank you in advance - jeremy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
time format
That is the way it does it, not good, but there it is I am afraid.
See http://www.cpearson.com/excel/DateTimeEntry.htm for quick time entry. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "ffjerm" wrote in message ... i've got a couple of questions. i trying to build a timing sheet in excel to track multiple race cars over multiple laps. I've got all the formulas figured out, but my problem is with data entry. there is a standard short cut to enter the current time (shift, ctrl, ;), but when i use this, it doesn't enter the seconds. I've formatted the cell as HH:mm:ss. any ideas here?? also, i know you can format the cells to auto fill, where i could type "345" and it will automatically change it to "$3.45". i've tried to use this with the above time format, but it changes it to a date and time default. it will only recognizes the decimal equivalent of time, whereas 093344 is converted to 07/25/2155 12:00 AM instead of 09:33:44 (hh:mm:ss). any help here would be greatly appreciated. thank you in advance - jeremy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
time format
thank you!!! this worked perfect. one more question......excel shows negative
time as "########", is there a way to change this default so the cell is blank instead? thanks again..... "Bob Phillips" wrote: That is the way it does it, not good, but there it is I am afraid. See http://www.cpearson.com/excel/DateTimeEntry.htm for quick time entry. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "ffjerm" wrote in message ... i've got a couple of questions. i trying to build a timing sheet in excel to track multiple race cars over multiple laps. I've got all the formulas figured out, but my problem is with data entry. there is a standard short cut to enter the current time (shift, ctrl, ;), but when i use this, it doesn't enter the seconds. I've formatted the cell as HH:mm:ss. any ideas here?? also, i know you can format the cells to auto fill, where i could type "345" and it will automatically change it to "$3.45". i've tried to use this with the above time format, but it changes it to a date and time default. it will only recognizes the decimal equivalent of time, whereas 093344 is converted to 07/25/2155 12:00 AM instead of 09:33:44 (hh:mm:ss). any help here would be greatly appreciated. thank you in advance - jeremy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting time from cell in 24 hr format | Excel Worksheet Functions | |||
Format number to Time in Excel? | Excel Worksheet Functions | |||
Time Format... | Excel Discussion (Misc queries) | |||
Time Format | Excel Discussion (Misc queries) | |||
Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) |