Hi,
I want to find the time difference between column1 & 2
I have indicated in the last column what I should be getting. Pls
assist.
Thank you and Rgds. :)

column1 column2 column1-column2 should be
23:45 00:15 23:30 minus 30mins
09:15 09:30 -00:15 correct
07:30 07:15 00:15 correct
00:15 23:45 -23:30 30mins


--
kvani
------------------------------------------------------------------------
kvani's Profile: http://www.excelforum.com/member.php...o&userid=27725
View this thread: http://www.excelforum.com/showthread...hreadid=472379