A
Adam
Hi All,
Mr Doug Steele answered a similar post to this previously, hopeing for
another type of answer as his answer worked a charm , see previous post
(http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us)
Anyway, I'm using Touchpaper Helpdesk (a database for Call logging in a
telephony centre)
In the data tables it records times as a large Integer .i.e the time
09:20:20 AM (hhmmss) reads as 152310784.
I'm using Access 97 to connect to the tables through ODBC and it works fine
however I want to search on times as well.
Below is the formula in Excel that converts the time integer into a usuable
time format of "hh:mm", note that the field [DB TIME ENCODED FIELD] is the
time interger .i.e as above 152310784.
=FLOOR([DB DATE ENCODED FIELD]/16777216,1)&":"&FLOOR((([DB DATE ENCODED
FIELD]-((FLOOR([DB DATE ENCODED FIELD]/16777216,1))*16777216))/65536),2)
I've posted something similar before on times but haven't had a resolution.
Has anyone got the skills/expertise to convert my excel formula into a
Module Code that reads as a time format?
Many Thanks !!
Mr Doug Steele answered a similar post to this previously, hopeing for
another type of answer as his answer worked a charm , see previous post
(http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us)
Anyway, I'm using Touchpaper Helpdesk (a database for Call logging in a
telephony centre)
In the data tables it records times as a large Integer .i.e the time
09:20:20 AM (hhmmss) reads as 152310784.
I'm using Access 97 to connect to the tables through ODBC and it works fine
however I want to search on times as well.
Below is the formula in Excel that converts the time integer into a usuable
time format of "hh:mm", note that the field [DB TIME ENCODED FIELD] is the
time interger .i.e as above 152310784.
=FLOOR([DB DATE ENCODED FIELD]/16777216,1)&":"&FLOOR((([DB DATE ENCODED
FIELD]-((FLOOR([DB DATE ENCODED FIELD]/16777216,1))*16777216))/65536),2)
I've posted something similar before on times but haven't had a resolution.
Has anyone got the skills/expertise to convert my excel formula into a
Module Code that reads as a time format?
Many Thanks !!