how to do calculation on time value?

[Former Member]

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. 

[som]

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.

[Henry_Banks]

i'd start by splitting the string into 2 parts 

[Former Member]

sorry i couldn't get you can you please be more specific??

[Henry_Banks]

I'm struggling to think of examples of this kind of data 00:00:06,00:01:10

so i suspect this formatting will be troublesome..if Lumira can't handle this using advanced acquisition properties, then it might be an idea to split it before coming into lumira . 

regards,

H