Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hI ,
I want sum of time in (hh:mm) in total column . so how we will write expression for summation of time in this format 'hh:mm'Administrator
time needs to be a field that has a numeric representation, like all date / time values created by QV itself.
See also this for more explanations on the date (and time) functions:
Then, your expression might just look like
=interval( sum(TimeField), 'hh:mm')
HI,
please find an attachment. in this file last column is for time and i want sum of that time in one row so how i will write expression for that .