Interval function

[tomgrouwe]

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?

[sunny_talwar · Accepted solution]

Try this:

Interval(Sum(#Uren)/24 - Sum([#Uren NB])/24, 'dd:hh')

[tomgrouwe]

Worked! Thank you very much