You rock! Worked like a charm. I was using =ABS(B1-A1) and not formatting it
as genral.....gave me strange date format results.

Your's worked great :)

Pete_UK wrote:
As long as those are entered as true date/times in Excel, you could do this:

=INT(B1-A1)

and format the cell as General.

Hope this helps.

Pete

Can anyone tell me how to do the following:

[quoted text clipped - 9 lines]
Any thoughts on how to do this?
Thanks a bunch for all the help!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200901/1