View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony tony is offline
external usenet poster
 
Posts: 313
Default 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