I displaying a range in Time within a cell in Excel.
 

I need to display a range within a cell in Time calculated from a set time in
Excel (i.e., cell A1 = "2:00pm" --- in cell A3 = "5:00pm to 8:00pm").

I displaying a range in Time within a cell in Excel.
 

=TEXT(A1+TIME(3,0,0),"h:mm AM/PM")&" to "&TEXT(A1+TIME(6,0,0),"h:mm AM/PM")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Moricj" wrote in message
...
I need to display a range within a cell in Time calculated from a set time
in
Excel (i.e., cell A1 = "2:00pm" --- in cell A3 = "5:00pm to 8:00pm").