Hello all,

I am importing a report from a phone reporter called ACD. When the reports
are ran in spreadsheet the time (duration) shows as the following:

303.58841

In order to get the actual time (duration) I have to take the number
303.58841 and divide it by 86400.

A formula I am using is the following:

=IF(ISERROR(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400),"0",(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400))

Which shows the correct time (duration) on Excel (05:04), when I export to
Access the time (duration) shows as 12:05:04 AM.

If I added MOD to the formula, would MOD fix the issue? And if yes, how
would I include MOD in the formula? And is formatting important when using
MOD with this formula?

Thanks for the help.

There is nothing wrong with what you have done, Access will display the time
in any format you wish, all you have to do is set the format in the query
design grid or on your forms / reports.

For help on this, post in: microsoft.public.access

MH

"JR" wrote in message
...
Hello all,

I am importing a report from a phone reporter called ACD. When the
reports
are ran in spreadsheet the time (duration) shows as the following:

303.58841

In order to get the actual time (duration) I have to take the number
303.58841 and divide it by 86400.

A formula I am using is the following:

=IF(ISERROR(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400),"0",(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400))

Which shows the correct time (duration) on Excel (05:04), when I export to
Access the time (duration) shows as 12:05:04 AM.

If I added MOD to the formula, would MOD fix the issue? And if yes, how
would I include MOD in the formula? And is formatting important when
using
MOD with this formula?

Thanks for the help.

Change the formatting of the time in ACCESS to LONG TIME. If it is set to
MEDIUM Time it will show as 12:05 AM.

HTH

"JR" wrote:

Hello all,

I am importing a report from a phone reporter called ACD. When the reports
are ran in spreadsheet the time (duration) shows as the following:

303.58841

In order to get the actual time (duration) I have to take the number
303.58841 and divide it by 86400.

A formula I am using is the following:

=IF(ISERROR(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400),"0",(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400))

Which shows the correct time (duration) on Excel (05:04), when I export to
Access the time (duration) shows as 12:05:04 AM.

If I added MOD to the formula, would MOD fix the issue? And if yes, how
would I include MOD in the formula? And is formatting important when using
MOD with this formula?

Thanks for the help.

The problem with leaving the time (duration) as a time is that I do not
proper variance times. Is there any way to fix this issue (with the
variance)?

"MH" wrote:

There is nothing wrong with what you have done, Access will display the time
in any format you wish, all you have to do is set the format in the query
design grid or on your forms / reports.

For help on this, post in: microsoft.public.access

MH

"JR" wrote in message
...
Hello all,

I am importing a report from a phone reporter called ACD. When the
reports
are ran in spreadsheet the time (duration) shows as the following:

303.58841

In order to get the actual time (duration) I have to take the number
303.58841 and divide it by 86400.

A formula I am using is the following:

=IF(ISERROR(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400),"0",(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400))

Which shows the correct time (duration) on Excel (05:04), when I export to
Access the time (duration) shows as 12:05:04 AM.

If I added MOD to the formula, would MOD fix the issue? And if yes, how
would I include MOD in the formula? And is formatting important when
using
MOD with this formula?

Thanks for the help.

What exactly are you trying to do here?

MH

"JR" wrote in message
...
The problem with leaving the time (duration) as a time is that I do not
proper variance times. Is there any way to fix this issue (with the
variance)?

"MH" wrote:

There is nothing wrong with what you have done, Access will display the
time
in any format you wish, all you have to do is set the format in the query
design grid or on your forms / reports.

For help on this, post in: microsoft.public.access

MH

"JR" wrote in message
...
Hello all,

I am importing a report from a phone reporter called ACD. When the
reports
are ran in spreadsheet the time (duration) shows as the following:

303.58841

In order to get the actual time (duration) I have to take the number
303.58841 and divide it by 86400.

A formula I am using is the following:

=IF(ISERROR(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400),"0",(VLOOKUP("D393",acd_dump!1:65536,5,FALS E)/86400))

Which shows the correct time (duration) on Excel (05:04), when I export
to
Access the time (duration) shows as 12:05:04 AM.

If I added MOD to the formula, would MOD fix the issue? And if yes,
how
would I include MOD in the formula? And is formatting important when
using
MOD with this formula?

Thanks for the help.