Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells
I would like to format a cell for am/pm without having to use a space in the
middle. ex 12:00 AM I would like to type in it as ex 12:00AM |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells
I looked into the link you sent me but wouldnt that refer my cells to
military time? I am looking for a way the cells can refer AM/PM "Geoff C" wrote: No easy way, a custom format can present it like that (h:mmAM/PM), but there's no equivalent of an informat. You may be able to adapt the VBA solution at http://www.cpearson.com/excel/DateTimeEntry.htm "Chris Cornell" wrote: I would like to format a cell for am/pm without having to use a space in the middle. ex 12:00 AM I would like to type in it as ex 12:00AM |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells
If you want an easy way to type in times, use 24-hour format. Then you never
need the am/pm. You can still display it in 12-hour format. If that's not acceptable, the next best is that you don't have to enter an 'am'. You do have to enter 'pm' (with a space). -- Regards, Fred "Chris Cornell" <Chris wrote in message ... I would like to format a cell for am/pm without having to use a space in the middle. ex 12:00 AM I would like to type in it as ex 12:00AM |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells
you can type 12:00AM Excel will treat as text not a real time
"Chris Cornell" wrote: I would like to format a cell for am/pm without having to use a space in the middle. ex 12:00 AM I would like to type in it as ex 12:00AM |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells
Thankyou,
"Fred Smith" wrote: If you want an easy way to type in times, use 24-hour format. Then you never need the am/pm. You can still display it in 12-hour format. If that's not acceptable, the next best is that you don't have to enter an 'am'. You do have to enter 'pm' (with a space). -- Regards, Fred "Chris Cornell" <Chris wrote in message ... I would like to format a cell for am/pm without having to use a space in the middle. ex 12:00 AM I would like to type in it as ex 12:00AM |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells
Do you think there may be a way to format the cell allowing the user to put
in 12:00AM and automatically converting the cell to read 12:00 AM? "Fred Smith" wrote: If you want an easy way to type in times, use 24-hour format. Then you never need the am/pm. You can still display it in 12-hour format. If that's not acceptable, the next best is that you don't have to enter an 'am'. You do have to enter 'pm' (with a space). -- Regards, Fred "Chris Cornell" <Chris wrote in message ... I would like to format a cell for am/pm without having to use a space in the middle. ex 12:00 AM I would like to type in it as ex 12:00AM |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells
With a helper column you could use the formula
=IF(RIGHT(A1,2)="AM",MOD(LEFT(A1,LEN(A1)-2),0.5),IF(RIGHT(A1,2)="PM",MOD(LEFT(A1,LEN(A1)-2),0.5)+0.5,"invalidsuffix"))You could allow already valid time formats by=IF(ISNUMBER(A1),A1,IF(RIGHT(A1,2)="AM",MOD(LEFT (A1,LEN(A1)-2),0.5),IF(RIGHT(A1,2)="PM",MOD(LEFT(A1,LEN(A1)-2),0.5)+0.5,"invalid suffix")))--David Biddulph"Chris Cornell" wrote in ... Do you think there may be a way to format the cell allowing the user toput in 12:00AM and automatically converting the cell to read 12:00 AM? "Fred Smith" wrote: If you want an easy way to type in times, use 24-hour format. Then younever need the am/pm. You can still display it in 12-hour format. If that's not acceptable, the next best is that you don't have to enter an 'am'. You dohave to enter 'pm' (with a space). -- Regards, Fred "Chris Cornell" <Chris wrote inmessage ... I would like to format a cell for am/pm without having to use a space inthe middle. ex 12:00 AM I would like to type in it as ex 12:00AM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
How to format cells in Excel for time in format mm:ss.00 | Excel Worksheet Functions | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |