Help with the SUM of Hours

[#1]

Hi

I have a situation with the SUM of Hours,

For example I SUM this Hours

2:00hr + 2:00hr + 2:00hr + 1:57hr and the result with this expression I’m using are 7.95hr and not the real result that is 7.57hr.

This is the expression I’m using:

Sum(Interval((interval#(HoursFac, 'hhhh:mm' )*24),'hhhh:mm'))

I will appreciate your help

Thanks.

[gandalfgray]

I'm guessing, but what if you set the Number format of the expression to "interval"?

/GG

[#3]

How I create the number format to interval?

Thanks ..

[MayilVahanan]

Hi,

     Can you say the format of your HoursFac?? data itself having hr. i.e. 2.00hr? Can you post a sample?

     Sum(Interval((interval#(HoursFac, 'hh:mm' )*24),'hh:mm'))

[gandalfgray · Accepted solution]

In the Chart properties

goto the Number tab,

mark the Expression

and tick the Interval

[#6]

Thanks it was the format ..