Importing and changing times

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chip193 - 27 Jul 2005 19:05 GMT

I have an excel worksheet that is sent to me on a regular basis for analysis.
I do the analysis in Access. Both are from the Office 2000 product.

When the times are sent to the Excel database, they are sent as text in the
form 0123 (24 hr clock). I need to convert them to times that Access can
understand.

I can change them in Excel using the TIME command, but the command provides
different output in Access.

Any ideas?

Thanks.

Reply to this Message

Klatuu - 27 Jul 2005 20:19 GMT

If you can always assume the text for the time will be 4 characters, with the
left 2 digits being hour and the right 2 being minutes, this will do it:
xlTime = "0123"
MyTime = TimeSerial(Val(Left(xlTime,2)),Val(Right(xlTime,2)),0)
now, MyTime = 1:23:00 AM

> I have an excel worksheet that is sent to me on a regular basis for analysis.
> I do the analysis in Access. Both are from the Office 2000 product.
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message