Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells with Time data
I'm trying to set up my spreadsheet to format my cells to hhmm, but every
time I try to enter data into the cells, the system automatically converts the hours I've entered into a date and leaves the time value at 0 any suggestions as to what I'm doing wrong? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells with Time data
Are you entering as hh:mm regardless of the cell format?
-- __________________________________ HTH Bob "yimkhoc" wrote in message ... I'm trying to set up my spreadsheet to format my cells to hhmm, but every time I try to enter data into the cells, the system automatically converts the hours I've entered into a date and leaves the time value at 0 any suggestions as to what I'm doing wrong? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells with Time data
If I enter as 18:00 with the colon, it's fine, but I'm trying to put together
a timesheet for the office and I wanted to be able to enter 1800 - that's when I have the problem "Bob Phillips" wrote: Are you entering as hh:mm regardless of the cell format? -- __________________________________ HTH Bob "yimkhoc" wrote in message ... I'm trying to set up my spreadsheet to format my cells to hhmm, but every time I try to enter data into the cells, the system automatically converts the hours I've entered into a date and leaves the time value at 0 any suggestions as to what I'm doing wrong? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells with Time data
Then you need some software to convert it. See
http://www.cpearson.com/excel/DateTimeEntry.htm -- __________________________________ HTH Bob "yimkhoc" wrote in message ... If I enter as 18:00 with the colon, it's fine, but I'm trying to put together a timesheet for the office and I wanted to be able to enter 1800 - that's when I have the problem "Bob Phillips" wrote: Are you entering as hh:mm regardless of the cell format? -- __________________________________ HTH Bob "yimkhoc" wrote in message ... I'm trying to set up my spreadsheet to format my cells to hhmm, but every time I try to enter data into the cells, the system automatically converts the hours I've entered into a date and leaves the time value at 0 any suggestions as to what I'm doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering/Formatting Time in Cells | Excel Discussion (Misc queries) | |||
formatting cells for time | Excel Discussion (Misc queries) | |||
formatting cells for time | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |