We are currently running our performance test in Loadrunner and in itself spits out csv export that's formatted like this: 38:06.1 - which equals to minutes, seconds and millisecond.
I can import into access database with format "Text" but how do I convert this into time (?) or number ... so that I can do some calculation? There is Time in and Time out columns with same format and I need to do some subtractions between the these 2 columns
When I try to import it using date/time format : mm:ss - only few gets imported correctly.
Example:
Thanks for your help.
Desire Result:
Time in Time Out Diff
38:00.0
38:06.1
6.1