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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top