? dt-clng(dt)
6:08:40 AM

should be

? dt-int(dt)
6:08:40 AM

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
demo's from the immediate window:

dt = Filedatetime("C:\data\KZ081-Default Survey1.xls")
? cdate(clng(dt))
3/18/02
? dt-clng(dt)
6:08:40 AM

--
Regards,
Tom Ogilvy


"Steven" wrote in message
...
I have a list of file names with their full name (ie Path + Name) in
column
A. 50 files total. Is there a macro or funtion that I can return the
last
saved date for each file in column B and the time it was saved in column
C?

Thank you for your help.

Steven