Bob Phillips Wrote:
Mod just takes the fractional part. As I read your post, C5:C160 was
date
and time and you just wanted the time, so I MOD it with 1 to get the
time,
and add these where K is blank.

--
HTH

Bob Phillips




thanks Bob - I'll play with that and see what I can come up with.

j


--
redneck joe


------------------------------------------------------------------------
redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570
View this thread: http://www.excelforum.com/showthread...hreadid=570547