Importing Data

K

Kev

I've been trying to import lengths of time into my table (ex. so and so
spent 01:30:00 [1.5 hrs] hours on the phone) from an excel spreadsheet. I
can not get access to recognize a 'duration' of time (1 hour 30 mins) as
opposed to an actual time (1:30 PM and/or AM). In excel you can set the cell
format as custom - hh:mm:ss, but access does not offer this format.

........Thanks in advance,
Kevin
 
J

Jeff Boyce

Kevin

Access has a Date/Time data type. It does not have a "duration" data type.

One approach would be to import time/duration as total minutes (or whatever
level of precision you'll need), then "parse" that number into a final
display version with a routine you write yourself.
 
Top