Hello to any who can help... and thank you.

I am converting from another application into excel, and the column for
time includes the seconds. I would like to be able to truncate the
seconds in order to perform a VLOOKUP. I can include every minute of
the day in 1440 rows, but seconds is just too many. Merely formatting
the cells, or rounding (i've tried converting to integers) doesn't work
because excel knows what's there, whether shown or not.

Thanks in advance for any help.
Kiley


--
tvtime
------------------------------------------------------------------------
tvtime's Profile: http://www.excelforum.com/member.php...o&userid=36676
View this thread: http://www.excelforum.com/showthread...hreadid=564159