473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help Getting A Time From Excel Into Access

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
2 1321
jaxjagfan
254 Expert 100+
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
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

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

Similar topics

1
by: Mitch | last post by:
I am using Access to create an Excel spreadsheets with graphs related to rows on the sheet1 to the graph on sheet2. I am using the same data but different subsets of the data to make different...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
2
by: Bill | last post by:
I have a 200 record database that includes a date/time field, AnnivDate, for a wedding anniversary. AnnivDate has nulls and some incorrect year data. I have been creating the Access database...
47
by: Jo | last post by:
Hi there, I'm Jo and it's the first time I've posted here. I'm in process of creating a database at work and have come a little unstuck.....I'm a bit of a novice and wondered if anyone could...
9
by: pic078 via AccessMonster.com | last post by:
I need serious help - I have a frontend/backend Access database (2 MDE Files) that remains stuck in task manager after exiting the application - you can't reopen database after exiting as a result...
4
by: Melissa | last post by:
I currently have VBA written to export query results into an Excel file. That file is then formatted using the code below. The problem I'm having is that it keeps throwing Error 91 (Object...
5
by: LadyIlsebet | last post by:
I'm not a fantastic Access developer, but I'm trying to help get Inventory and whatnot organized at work. They are used to 5 year budget plans that list out exactly what has to be purchased what...
2
risk32
by: risk32 | last post by:
OK. So I have NO idea what I'm doing. I've only worked with Excel VBA, JS, and HTML. No clue how to use access since it's different (except maybe the VB portion of Excel VBA). I'm trying to make a...
4
by: ndedhia1 | last post by:
I am reading in a file to see what delays I am getting on what IP address: QuoteBlockTiming exceeded 1000 ms: 1684 --- Fri Nov 06 06:09:10 CST 2009 170.137.94.95 Class key = 649126730 block...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.