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.