Thats great! but the problem i am running into now is my coloring of
cells for the time starts at 6:00 or 6am but the furthest I can start
my coloring is in column F so it = 3:00 or 3am using the calling
=GetTime(A28:AQ28,36,TRUE) A=12 by the time you get to F it is only 3am
so is there a way to start column F at 6:00 or 6am?


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=513916