Thread
:
Combining two formulas using concatenate
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Biff
external usenet poster
Posts: 1,688
Combining two formulas using concatenate
How about this:
=TEXT($C$17-TIME(1,45,0),"hh:mm")&" - "&TEXT($C$17-TIME(1,15,0),"hh:mm")
Biff
"Confused Kate" <Confused
wrote in message
...
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 Quote
Biff
View Public Profile
Find all posts by Biff