time equation

[HappyChappy]

i have 50:00 in cell c1 3:35 in c2 when i put c1-c2 i get 04:48 i should be getting 46:25 cant seem to figure it out sure there is a simple reason its not returning the correct figure

 

[awoohaw]

Sorry to have repeat post.

EDIT: I just realized, if you ever have a time of MIDNIGHT, you may get this error. UGH.
So, maybe only check for blank cells:

=IF(OR(C3="",D3=""),0,YourFormula)

But those will cause downstream errors in your other formulas.
You can fix those with the N() function.

like this:

=N(G3)-N(J3)

or you can use the SUM() function with delimited cell references

=SUM(G3,J3)

But in all the columns with calculations that reference column G,I,J,&K. (I think those are the columns)