Change format on data that is imported from Access

[jcaptchaos2]

I have some data that is brought in from an Access database query, in the access query the data is formatted as short time. When it is pulled into my excel spread sheet it is formatted as text. '8:12 I need to add that data and the only way I am able to do that is highlight the column of data in the table and use the text to column feature to remove the '. The only issue is when the table is refreshed I will have to do it over and over again. Is there another way to do it?

 

[xenou]

^^ ditto Norie's last question.

 

[jcaptchaos2]

Total Time: IIf([ParollTimeOfftbl].[Date] Is Not Null,DateDiff("n",[ParollTimeOntbl].[Date]+CDate(Format([ParollTimeOntbl].[Time On],"Long Time")),[ParollTimeOfftbl].[Date]+CDate(Format([ParollTimeOfftbl].[Time Off],"Long Time"))),0)\60 & Format([Total Minutes] Mod 60,"\:00")

 

[Norie]

You are using Format in that expression, so perhaps somehow the expression is returning text.

 

[jcaptchaos2]

Thanks for the feedback Norie