Thread: formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chefmike chefmike is offline
external usenet poster
 
Posts: 38
Default formula help

I need some help, I am using Excel 2003 and need help with a formula. Cell
"B4" has a time entered into it, lets say 7:00 AM; Cell "B5" has a time
entered also, lets say "15:30 PM. In cell "F6" I would to combine these two
times in the cell to look like "7:00-3:30". Hope this is possible and if it
is how would I do it.
If any more information is needed let me know.
Thanks in advance