| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format parts of cell differently
I am using combining two time cells into one cell along with a separator of "
- ". Source Cell J4 - "11:00 am" Source Cell K4 - "11:30 am" Target Cell C4 - "11:00 - 11:30 am" How do can I do this and get the right formatting? I am currently getting: 0.34375 - 0.688194444444444 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format parts of cell differently
=text(j4,"hh:mm AM/PM") & " - " & text(k4,"hh:mm AM/PM")
I included the AM/PM in the formatting for the first time. Tony wrote: I am using combining two time cells into one cell along with a separator of " - ". Source Cell J4 - "11:00 am" Source Cell K4 - "11:30 am" Target Cell C4 - "11:00 - 11:30 am" How do can I do this and get the right formatting? I am currently getting: 0.34375 - 0.688194444444444 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format parts of cell differently
Dave, all I need to do now is apply to the following column/cell reference:
wsPh.Range("c" & EMcnt) = "Dave Peterson" wrote: =text(j4,"hh:mm AM/PM") & " - " & text(k4,"hh:mm AM/PM") I included the AM/PM in the formatting for the first time. Tony wrote: I am using combining two time cells into one cell along with a separator of " - ". Source Cell J4 - "11:00 am" Source Cell K4 - "11:30 am" Target Cell C4 - "11:00 - 11:30 am" How do can I do this and get the right formatting? I am currently getting: 0.34375 - 0.688194444444444 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format parts of cell differently
Does that mean you want to put the formula in that cell?
wsPh.Range("c" & EMcnt).Formula _ = "=text(j" & EMcnt & ",""hh:mm AM/PM"") & "" - """ _ & "&text(k" & EMcnt & ",""hh:mm AM/PM"")" Tony wrote: Dave, all I need to do now is apply to the following column/cell reference: wsPh.Range("c" & EMcnt) = "Dave Peterson" wrote: =text(j4,"hh:mm AM/PM") & " - " & text(k4,"hh:mm AM/PM") I included the AM/PM in the formatting for the first time. Tony wrote: I am using combining two time cells into one cell along with a separator of " - ". Source Cell J4 - "11:00 am" Source Cell K4 - "11:30 am" Target Cell C4 - "11:00 - 11:30 am" How do can I do this and get the right formatting? I am currently getting: 0.34375 - 0.688194444444444 -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format parts of cell differently
Thanks Dave, works like a charm.
"Dave Peterson" wrote: Does that mean you want to put the formula in that cell? wsPh.Range("c" & EMcnt).Formula _ = "=text(j" & EMcnt & ",""hh:mm AM/PM"") & "" - """ _ & "&text(k" & EMcnt & ",""hh:mm AM/PM"")" Tony wrote: Dave, all I need to do now is apply to the following column/cell reference: wsPh.Range("c" & EMcnt) = "Dave Peterson" wrote: =text(j4,"hh:mm AM/PM") & " - " & text(k4,"hh:mm AM/PM") I included the AM/PM in the formatting for the first time. Tony wrote: I am using combining two time cells into one cell along with a separator of " - ". Source Cell J4 - "11:00 am" Source Cell K4 - "11:30 am" Target Cell C4 - "11:00 - 11:30 am" How do can I do this and get the right formatting? I am currently getting: 0.34375 - 0.688194444444444 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format Displays Differently Between Users | Excel Discussion (Misc queries) | |||
| Date glitch? First 12 days of month format differently than the r | Excel Discussion (Misc queries) | |||
| How do you format each slice differently in a 3-D pie chart? | Charts and Charting in Excel | |||
| open Excel formatted differently than the default format | Excel Discussion (Misc queries) | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Linear Mode
