Export excel formula to access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lina Arraiz
    New Member
    • Jul 2010
    • 3

    #1

    Export excel formula to access

    I'm trying to export an Excel 2003 spreadsheet to Access 2007. I need to calculate the time elapsed between column D (START) and column E (END) with the results appearing in column F (TIME). The Excel formula, which is placed in column F, goes like this: =24*(IF(E2>D2,D 2-E2)) Exactly what language do I use in Access and where do I put it in order to get the same results? I appreciate your help ... I'm totally stumped!
Working...