Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In the Chart properties
goto the Number tab,
mark the Expression
and tick the Interval
I'm guessing, but what if you set the Number format of the expression to "interval"?
/GG
How I create the number format to interval?
Thanks ..
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'))
In the Chart properties
goto the Number tab,
mark the Expression
and tick the Interval
Thanks it was the format ..