Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to input a time without the seconds showing
I have tried to format the cell by using both general and time formats. When
using h:mm AM/PM the seconds till show up. I am using this for a mail merge and don't want the time to reflect seconds. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to input a time without the seconds showing
Hi Tara
FormatCellsNumberCustom h:mm -- Regards Roger Govier "Tara" wrote in message ... I have tried to format the cell by using both general and time formats. When using h:mm AM/PM the seconds till show up. I am using this for a mail merge and don't want the time to reflect seconds. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to input a time without the seconds showing
If you're talking not about how the cells are displayed in Excel, but how
the data appears in a mail merge in Word, try http://office.microsoft.com/en-us/wo...164951033.aspx The easy option is to produce a helper column using the TEXT() function. -- David Biddulph "Tara" wrote in message ... I have tried to format the cell by using both general and time formats. When using h:mm AM/PM the seconds till show up. I am using this for a mail merge and don't want the time to reflect seconds. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to input a time without the seconds showing
Thank you but in doing so it converts the time to a 24 hour clock and I need
it to remain 12 hour (2:00 PM vs 14:00) Tara "Roger Govier" wrote: Hi Tara FormatCellsNumberCustom h:mm -- Regards Roger Govier "Tara" wrote in message ... I have tried to format the cell by using both general and time formats. When using h:mm AM/PM the seconds till show up. I am using this for a mail merge and don't want the time to reflect seconds. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to input a time without the seconds showing
Hi
Then try FormatCellsNumberCustom h:mm AM/PM -- Regards Roger Govier "Tara" wrote in message ... Thank you but in doing so it converts the time to a 24 hour clock and I need it to remain 12 hour (2:00 PM vs 14:00) Tara "Roger Govier" wrote: Hi Tara FormatCellsNumberCustom h:mm -- Regards Roger Govier "Tara" wrote in message ... I have tried to format the cell by using both general and time formats. When using h:mm AM/PM the seconds till show up. I am using this for a merge and don't want the time to reflect seconds. |
#6
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
Convert Seconds and decimals to time | Excel Discussion (Misc queries) | |||
Time input mask format | Excel Discussion (Misc queries) | |||
How do I change . to : when input in a time sheet by error | New Users to Excel | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |