| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to drop the date from a time format?
I am trying to design a time sheet for the organisation. If I enter the time
as 9:00 it stays as 9am... if I just enter 900, it goes to 18/06/1902 12:00:00 AM - is there anyway to get it to see 900 as 9:00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get Excel to drop the date from a time format?
lozzielou,
You have to format the cells the way that you want excel to handle the information that you enter. So select a cell, Format, Cells, Category: "Time" and Type: "13:30" You will still have to enter 9:00 am as "9:00" . hth "lozzielou" wrote: I am trying to design a time sheet for the organisation. If I enter the time as 9:00 it stays as 9am... if I just enter 900, it goes to 18/06/1902 12:00:00 AM - is there anyway to get it to see 900 as 9:00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003- Charts- date and time format on x-axis of XY chart | Charts and Charting in Excel | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Drop time in date/time field | Excel Worksheet Functions | |||
| DOS Data in Excel Format with Date and Military Time in same cell | Excel Worksheet Functions | |||
Linear Mode
