I is easy to convert a number into a date. Excel stores the date as a
number with Jan 1, 1900 equal 1 and ech day afterwards is equalk to 1.
One hour equal 1/24, 1 minute equals 1/(24*60). You could write your
own function to convert a number to a date and a date to a number.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=160426
Microsoft Office Help