First of all, my apologies for originally posting this question in the wrong section. I'm trying to export an Excel 2003 spreadsheet to Access 2007. Column D (START) has the start time and Column E (END) has the end time.
I need to calculate the time elapsed between these two columns with the results appearing in column F (TIME). I don't have dates in my Excel spreadsheet, just times: 8:00:00 AM. The result comes out in Column F like this: -0.75. The Excel formula I've placed in column F is the following:
=24*(IF(E2>D2,D 2-E2))
Exactly what language do I use in my Access database in order to get the same results that I have in my Excel spreadsheet and where do I put it? I appreciate your help as I'm totally stumped!
I need to calculate the time elapsed between these two columns with the results appearing in column F (TIME). I don't have dates in my Excel spreadsheet, just times: 8:00:00 AM. The result comes out in Column F like this: -0.75. The Excel formula I've placed in column F is the following:
=24*(IF(E2>D2,D 2-E2))
Exactly what language do I use in my Access database in order to get the same results that I have in my Excel spreadsheet and where do I put it? I appreciate your help as I'm totally stumped!
Comment