Need help with a formula that converts times listed using data verification into hours.

Need help with a formula that converts times listed using data verification into hours. For example 2pm - 10pm = 8 hrs. The formula I'm currently using works fine until the times run past 12pm. Then it creates an error because it generates a negative number. =IFERROR(IF(D75<C75,(24*D75-C75),IFERROR(D75-C75,"")),"") Where D75 is 11:30pm and C75 is 2:30pm the formula generates the result of 9:00 which is correct. But if D75 is changed to 12:00am it generates and error because the result is a negative number.

Thank you for your help. But this returns a result of 0:00.

Would you be willing to look at the workbook?

Yes ... it helps if there is data work with.

How can I send the workbook?

Here's the work book. It is a scheduleing tool that is suppost to calculate hours scheduled vs. hours forecasted.
It works fine until one of the times selected goes beyond 12am, it then creates an error because the result is a negative number.

Try

=IFERROR(D75-C75+(D75<C75),"")

Thanks that works. Much Appreciated!!!

Thanks for the feedback and rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.