Sum Time in Hours (HH:MM)

[#1]

Greetings!!!

I have a little issue, and have exhausted my ideas and found no solution...

I have a field that contains time amounts like in the format 'HH:MM', like that

TIME
----------------------------
00:20
00:36
01:15
06:37

And I want to create a chart to show the total amount of time per Day/Month/Year etc... but the SUM() function does not work properly, and I don't know how to dismenber the data to sum it the right way.

Any thoughts?

Thank you all!!!

[#2]

There's the file!

Started my week being a NOOB! =$

Standing by your lightshed John!

Thanx everyone!

[marjan_it]

how to get sum of 2 time field that have more than 24 hours

I want to get sum 2 time in expression in qlikview like this: 20:25:50 and 22:45:15

And in result show this:43:11:05

[rubenmarin]

As John said,

try Interval(TotalTempoDisponibilidade, 'hh:mm') as TotalTempoDisponibilidade

Edit: sorry didn't see the date of the post. Marjan, you can use Interval(Sum(TimeValueField), 'hh:mm:ss')

Regards

[marjan_it]

but my TimeValueField is in 2 different  field: field A:20:25:50  and field B: 22:45:15

[vinieme12]

Like below

load  Sum(Interval(Time,'hh:mm')) as TotalTime  inline [

Time

00:20

00:36

01:15

06:37

];

[PASTORGAA]

thanks for your reply

best regards