Hi D

strA = Format((FileDateTime("C:\Temp\Book1.xls")), "h:mmAM/PM")

Regards,
Per

"Daniel Jones" skrev i meddelelsen
...
Is there a way to return just the time from the FileDateTime method?

i.e. id like strA to return "5:00PM" instead of "11/30/09 5:00PM"

strA = FileDateTime("C:\Temp\Book1.xls")

Thanks!

D