on 04-30-2014 4:41 PM
I have "Duration" as a column in a source excel file which contain data like 00:00:06,00:01:10 when i connect this excel to lumira i am getting the column data as [$-5400]12:00:06\AM
please specify how to perform certain calculation on time value like sum or avg.
Ankur
Is the HH:MM:SS?
Lumira has an enhancement request to better handle hour, minute, seconds . Until we have it I am afraid there isn't too much way around this at the moment.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i'd start by splitting the string into 2 parts
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.