sum time values

[Anonymous]

hi,

i have feild that show time 1.36(1hour & 36 minute )

if i write in expression sum(feild1) the result is 5.44 (i have 4 line with that 1.36 )

how do i write to get the result in hour - 6.24 - 6 hour & 24 minute ?

thanks'

yarin.

[fgolmahi]

hi

please help me

I could not sum a column.

Thank you for your help

[tresesco]

Hi @fgolmahi , I don't have a qv license yet (hoping to get one soon from qlik as an MVP). So can't open your qvw and check what/how you are trying. Please post your expression/ screen shot and expected result w.r.t. the sample data you shared. 

[fgolmahi]

Hi, thank you for your help
Yes, I use the server version at work and I have no problem opening files.
If possible, please guide me to the field of the attached file.

my expression is      =Time(Sum(time#(timeee, 'h:mm')),'h:mm')

[fgolmahi]

@tresesco 

Hi, thank you for your help
Yes, I use the server version at work and I have no problem opening files.
If possible, please guide me to the field of the attached file.

my expression is      =Time(Sum(time#(timeee, 'h:mm')),'h:mm')

[tresesco]

@fgolmahi 

I have problem opening the file. I got your expression, now let me know your expected output and what you are getting using the above expression while using the excel data you shared. 

[fgolmahi]

Hi @tresesco 

Yes, I use this expression, but unfortunately it calculates incorrectly and calculates integer.

please help me 😞

for example  sum  following fields :

05:09

03:32

00:41

05:01

02:44

01:17

00:00

00:40

03:48

03:13

00:48

02:50

05:05

[tresesco]

@fgolmahi 

While working on timestamp and it's formatting there are important catches and that is the reason I wanted to emphasis on 'your expected output'. I guess you need interval(), something like:

Interval(Sum(time#(timeee, 'h:mm')),'h:mm') 

Or, simply

Interval(Sum(timeee),'h:mm') 

[fgolmahi]

Thank you for your help. @tresesco 

Your comments were excellent and I  able to get the right answer.

Thank you very much.