Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to SUM up a DATE/TIME field in code...
I'm connecting to an Access Database using ADODB and would like to sum up the
total values for a Date/Time field called Duration. The SQL I'm using to get this is: "SELECT SUM(Duration) FROM 3_REPORT;" I am using Excel as my interface and when I run this SQL it returns this value: "1.6937569511234E+190" regardless of how I format the cell. I was expecting something like 24:14:01. If I just cut and paste my data from Access into Excel, then use the excel function so sum up the total duration, then it gives me what I want. I would like to do this in the code though. Any ideas what I'm doing wrong, or how to get around this? Thanks in advance. -- Rone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you combine a date field and a time field into one? | Excel Worksheet Functions | |||
removing/ignoring time in a date time field | Excel Discussion (Misc queries) | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Drop time in date/time field | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |