Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I'm having a problem with the interval function.
The formula is as following:
SUM(A)/24 - SUM(B)/24 = dd:hh
To do this i have the following definition:
INTERVAL(SUM(#Uren)/24, 'dd:hh')
-
Interval(SUM([#Uren NB])/24,'dd:hh')
The problem is that the outcome isn't formatted as dd:hh but as ###,##.
What am I doing wrong?
Try this:
Interval(Sum(#Uren)/24 - Sum([#Uren NB])/24, 'dd:hh')
Worked! Thank you very much