Problem with a Duration Formula Calculation

[Inao_Vasquez]

Hi!, I have a simple formula for a Duration column. Is part of a conditional expression to fix duration calculation when an end time is after midnight.

where A2 is a Time after midnight, for example 00:59.

And A1 is a time before midnight for example 23:59.

Formula is: [A2] - [A1] + 24

But instead of receive 1:00  as the result for the example values, I receive: -1:00. There is something i Miss? numbers should be expressed in another way in the formula?

I

[Joseph_Seddik · Accepted solution]

[A2] - [A1] + "024:00:00"

and generally you can use:

[A2] - [A1] + IF( [A2] < [A1], 
  "024:00:00",
  "000:00:00"
)

[Inao_Vasquez]

Thanks a lot KJ_Seddik 

nailed it!