Thread: Combining two formulas using concatenate
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Combining two formulas using concatenate
Try:
=TEXT(C17-TIME(1,45,0),"hh:mm")&"Â*"&TEXT(C17-TIME(1,15,0),"hh:mm")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Confused Kate" wrote:
Here is the formula I've tried that isn't working:

Â*=concatenate(text(=$c$17-time(1,45,0),"hh:mm"),"Â*",text(=$c$17-time(1,15,0),"hh:mm"))

Is it possible to put these two formulas together? Basically, I need the
time to look like 07:15-07:45. These times pull off of cell C17. If C17 is
changed this range of time needs to change. How do I program excel to do
this?
Reply With QuoteReply With Quote