calculating averaqe time from varchar datatype
-
I hope you can help me... I store an elapsed time value as a string (varchar) (mm:ss) in my SQL database. When I query the data from Excel, how can I calculate an average from this data? Would it help if I made the SQL datatype some kind of time value? Thanks in advance for any advice you may provide. 'til next we type... HAVE FUN!! -- Jesse
-
I hope you can help me... I store an elapsed time value as a string (varchar) (mm:ss) in my SQL database. When I query the data from Excel, how can I calculate an average from this data? Would it help if I made the SQL datatype some kind of time value? Thanks in advance for any advice you may provide. 'til next we type... HAVE FUN!! -- Jesse
Jesse Evans wrote: When I query the data from Excel, how can I calculate an average from this data? Why are you storing it as a string? I would store it as an integer and if you needed in the format mm:ss a simple calculated field could be created for that function.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar The Second EuroCPian Event will be in Brussels on the 4th of September Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way! My Blog
-
I hope you can help me... I store an elapsed time value as a string (varchar) (mm:ss) in my SQL database. When I query the data from Excel, how can I calculate an average from this data? Would it help if I made the SQL datatype some kind of time value? Thanks in advance for any advice you may provide. 'til next we type... HAVE FUN!! -- Jesse