Time Format

[rkisor]

Hi Team,

I 'm downloading the excel data from the site and connecting it to access.
In excel the particular column (Time Taken) is in the format of "00:12:26".

After connecting it to access and appending it to the table, the format changed to "12:12:26", the first two digits changed to "12" and the remaining are as it is how it looks like in the excel. I need to change it to format what it looks like in the excel.

Please help.

Thanks
Kishore

 

[Galaxiom]

Is there no "AM" in the Excel format?

If there is, simply Format the column to 24 hour time.

 

[rkisor]

There is no AM in the excel. I cant do anything in excel, its readonly . And day on day new data gets added .i want make changes in the access itself. How to do that. Please help.

 

[JHB]

I don't know if it help you, but I would try by changing the format for the field's property to "hh:nn:ss AM/PM".

 

[rkisor]

I got another question. In the excel I have chat field. The time format for few cells comes with date.

The Excel raw data what i'm using for my project it will be read only, so i'm not able to make any changes. I'm will upload the data to MS access 2010. In MS Access i tried many times to change the format, i cant make it. Please help.

In the same excel another field Engage time comes with hh:mm:ss , here also sometimes comes with date format. For example as per excel its comes with 60:12:45 after connecting it to MS access it changed to 5:12:45. Only the first two digits got changed , rest are no changes, How to fix it please help.

Example is shown below.

Chat Time Engage Time
1/0/1900 0:00 1/0/00 12:24
1:00:00 AM 34:45:96
2:00:00 AM 13:67:78
1/0/1900 3:00 78:65:78

Thanks
Kishore

 

[JHB]

I don't know what you are trying to achieve, other as importing the data into MS-Access. Can you explain something more!

In MS Access i tried many times to change the format, i cant make it. Please help.

Change it from what to what?

What does 60:12:45 mean? And what result do you want/expect?

And what does the below?

Chat Time Engage Time
1/0/1900 0:00 1/0/00 12:24
1:00:00 AM 34:45:96
2:00:00 AM 13:67:78
1/0/1900 3:00 78:65:78

 

[Foe]

?TimeValue("00:12:26")
12:12:26 AM

?Format(TimeValue("00:12:26"), "hh:nn:ss")
00:12:26


I didn't follow what you're asking in the second post about chat times.

 

[rkisor]

Hi thanks team. I got it