Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hh:mm:ss keeps converting to a date
I am trying to work on a spreadsheet for work where I am keeping track of
time by hours, minutes and seconds. I format the cells for hh:mm:ss.00 but each time I enter the hours, seconds, minutes, it converts to a date field and changes to another hh:mm:ss value. The value I have entered is 42:37:26 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hh:mm:ss keeps converting to a date
Select your date cells and then click on FORMAT and then select cells. In
the CATEGORY pane select CUSTOM and then in the type pane select the following format: [h]:mm:ss -- Kevin Backmann "Brian James" wrote: I am trying to work on a spreadsheet for work where I am keeping track of time by hours, minutes and seconds. I format the cells for hh:mm:ss.00 but each time I enter the hours, seconds, minutes, it converts to a date field and changes to another hh:mm:ss value. The value I have entered is 42:37:26 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hh:mm:ss keeps converting to a date
Hi Brian,
The hh:mm:ss format is interpreting hours 24 as days and then shows the remainder. Creating a special format of [h]:mm:ss.00 gets round this Anthony "Brian James" wrote: I am trying to work on a spreadsheet for work where I am keeping track of time by hours, minutes and seconds. I format the cells for hh:mm:ss.00 but each time I enter the hours, seconds, minutes, it converts to a date field and changes to another hh:mm:ss value. The value I have entered is 42:37:26 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hh:mm:ss keeps converting to a date
I am not getting the problem, but maybe if you format as [h]:mm:ss
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Brian James" <Brian wrote in message ... I am trying to work on a spreadsheet for work where I am keeping track of time by hours, minutes and seconds. I format the cells for hh:mm:ss.00 but each time I enter the hours, seconds, minutes, it converts to a date field and changes to another hh:mm:ss value. The value I have entered is 42:37:26 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
hh:mm:ss keeps converting to a date
Brian James wrote:
I am trying to work on a spreadsheet for work where I am keeping track of time by hours, minutes and seconds. I format the cells for hh:mm:ss.00 but each time I enter the hours, seconds, minutes, it converts to a date field and changes to another hh:mm:ss value. The value I have entered is 42:37:26 Hi Brian, try to format with Custom format. Menu Format, Cells, Number tab, under Categories choose Custom, then type this format string in the text box: [h]:mm:ss.00 -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
converting date to number | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
converting julian day and year to a date? | Excel Worksheet Functions | |||
Can stop excel from converting value to date? | New Users to Excel |