By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Help Getting A Time From Excel Into Access

P: 6
Hi,

I've been trying to import a spreadsheet from excel into access but the way it is downloaded from the site we use to review our performance some cells are like the following:

The cell shows - 35:34:00

But when you click into the cell the forumla/information behind it is - 01/01/1900 11:34:00.

The actual info I want is 35:34:00 to show into access but it shows the 01/01/1900 11:34:00 and I can't get it to format to show 35:34:00.

When I click on the format settings in excel it shows [h}:mm:ss but you can't do this in access I've tried [h}:nn:ss but this doesn't show 35:34:00.

I'm really stuck and unsure of the best way to resolve this the problem is this isn't the same for each cell so it's not a particular column it's just random..

Any help appreicated. Thanks in advance.

Tara
Jan 7 '08 #1
Share this Question
Share on Google+
2 Replies


jaxjagfan
Expert 100+
P: 254
Hi,

I've been trying to import a spreadsheet from excel into access but the way it is downloaded from the site we use to review our performance some cells are like the following:

The cell shows - 35:34:00

But when you click into the cell the forumla/information behind it is - 01/01/1900 11:34:00.

The actual info I want is 35:34:00 to show into access but it shows the 01/01/1900 11:34:00 and I can't get it to format to show 35:34:00.

When I click on the format settings in excel it shows [h}:mm:ss but you can't do this in access I've tried [h}:nn:ss but this doesn't show 35:34:00.

I'm really stuck and unsure of the best way to resolve this the problem is this isn't the same for each cell so it's not a particular column it's just random..

Any help appreicated. Thanks in advance.

Tara
Is this value being calculated in Excel (YourEndDateTime - YourBeginStartTime) or something in that fashion? If so you can import the 2 date/times and just display the results in a query or textbox. Format((YourEndDateTime - YourBeginDateTime),"hh:nn:ss")
Jan 7 '08 #2

P: 6
Hi,

No it's not a forumla in excel it's downloaded from a system we use and it is just data so no formulas. I understand it is because of the 24hr clock in excel and if it goes over 24hrs it uses this format is there something similar in access. I'm not great with vba so hoping for something simple.

Tara
Jan 8 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.