Help with rounding in Access and Excel

[nbrock2002]

Hello,



I have an excel file that is used for our timesheet. We import that information into Access. My problem is that we have a formula to show how many hours worked to the nearest tenth on the timesheet itself before importing (Employees visually get to see). I then import and run a query to determine hours worked on the access side (we may adjust times so needs a formula and not just total hours worked). I need to determine hours worked in both Excel and Access and they need to match. I've got my head around bankers rounding and arithmetic rounding and why I'm not matching but I need to come up with a solution so they both come to the same conclusion.

I am willing to change Excel's or Access' formulas (or both) to get it to work. I would like to refrain from using VBA to run a query because I'm not yet familiar with that. Currently I am using "ROUND((TimeOut-TimeIn)*24,1))" as my formula in both Excel and Access. Any advice?

[June7]

Round() in Access uses bankers (even/odd) rule. In Excel it does not.

Format() function in Access does not use bankers.

Consider:

CDbl(Format(3.45,"0.0"))

[orange]

I suggest you show us some examples.
Show us what you have; what you have tried; and what you want it to show.

[ssanfu]

PMFJI,

Don't know if this will help you - here are a couple of sites with info about Access/Excel rounding:

Rounding in Access: http://www.allenbrowne.com/round.html
Access Round Function: http://access-excel.tips/access-roun...nd-even-logic/




And Welcome to the forum.....