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?

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 (E-Mail Removed)> wrote in message
news:72F5C44B-5E4F-4D90-83A7-(E-Mail Removed)...
> 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?

You're getting close. You don't use equal signs in functions (only at the start
of a formula). And you need a dash inside the quotes of the second parameter.
Try:

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

--
Regards,
Fred


"Confused Kate" <Confused (E-Mail Removed)> wrote in message
news:72F5C44B-5E4F-4D90-83A7-(E-Mail Removed)...
> 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?

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?