Times greater than 24 hours

[ccordner]

Good Afternoon

I am using a database and need a field capable of storing times that will be greater than 24 hours.

I understand there is no "ready made" way of dealing with this in Access, so what's the best way?



The catch is I am using VBA code in Excel to populate the table, the value comes from a cell (in Excel formatted as "[h]:mm").

Any ideas?

Thanks
Chris

[John_G]

Hi -

Access has no data type that stores "amount" of time. You have two choices. First is to store the starting point and ending point of the time interval, and calculate the difference when you need it.

If you really need to store "amount" of time greater than 24 hours, then you will need to use a normal numeric field. Whether you use hh.mm (e.g. 9.15 would be 9 hours, 15 minutes) or decimal hours (e.g .9.25 hours is also 9 hours 15 minutes) is up to you, but you cannot easily do calculations with the former method.

You could always write a function to display 9.25 hours as 9:15 when you need to.

HTH
John

[ccordner]

Thanks

I think you're right about storing it as 9.25 hours. Probably easier in the long run.

Chris