Here's what I have:


Code
-------------------
tih = Selection
ActiveCell.Offset(0, 1).Select
tih2 = Selection
ActiveCell.Offset(0, 2).Select
tim = Selection
ActiveCell.Offset(0, 1).Select
tim2 = Selection
TimeIn = tih & tih2 & tim & tim
-------------------



TimeIn = "0745"

How do I make the expression TimeIn have a value of 7:45 instead o
745

--
hyyft
-----------------------------------------------------------------------
hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318
View this thread: http://www.excelforum.com/showthread.php?threadid=26549