close
I need to display a range within a cell in Time calculated from a set time in
Excel (i.e., cell A1 = quot;2:00pmquot; --- in cell A3 = quot;5:00pm to 8:00pmquot;).
=TEXT(A1 TIME(3,0,0),quot;h:mm AM/PMquot;)amp;quot; to quot;amp;TEXT(A1 TIME(6,0,0),quot;h:mm AM/PMquot;)
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
quot;Moricjquot; gt; wrote in message
...
gt; I need to display a range within a cell in Time calculated from a set time
in
gt; Excel (i.e., cell A1 = quot;2:00pmquot; --- in cell A3 = quot;5:00pm to 8:00pmquot;).
全站熱搜
留言列表
