Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I retrieve data where I have seconds on every line. I'm totalling the rows and using Interval to convert seconds into 'd hh:mm:ss' which is working fine, however the days are taken as 24 hour days where I would like to specify the no of hours per day.
My current interval line is as follows :-
Interval(Interval#(ActualWorkTime,'ss'),'d hh:mm:ss') as ActualTimeH,
which is returning the table below. What do I need to do to the above line to set an 8 hour day?
Thanks
Steve
can't you multiply by 3?
can't you multiply by 3?
=Dual(Div(ActualWorkTime,28800)&' '&Interval(fmod(ActualWorkTime,28800)/86400, 'hh:mm:ss'), ActualWorkTime)
Hi,
can you post an example app?
thanks
regards
Marco