MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Links in Excel


Posted by Hannes Germishuys on February 06, 2002 6:12 AM

Hi

I'm currently migrating huge amounts of Excel sheets to another directory, what is the easiest way to find out where those links are and to replace them with new ones. ??


Posted by Steve Hartman on February 06, 2002 6:35 AM

Use the INT() and MOD() functions

=INT(46) will give you the 5 days
=MOD(46,8) will give you the 6 hours