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").

=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" <[email protected]> wrote in message
news:[email protected]...
> 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").