Subtracting times / Converting to Min

[dreicer_Jarr]

I wrote a formula that subracts to times and gives me minutes (example below):

For 23:34 (Row d) and 23:39 (row F) the answer is five min using the following formula:

=IF(F5790>0,IF(D5790>0,(F5790-D5790)*1440," ")," ")

But when the clock strikes 12 am at night, 1440 must be added to this formula or you get an error. So the forumla below gives an error for times like 23:53 (Row d) and 0:03 (row F), but I manually sort and fix these errors by using this forumla:

=IF(F6832>0,IF(D6832>0,(F6832-D6832)*1440," ")," ")+1440

The answer is 10 min.

How can I combine these formulas to be more efficient?

JPD

[NBVC]

Perhaps?

Please Login or Register  to view this content.

[dreicer_Jarr]

It is always you who helps me. Thanks.

[NBVC]

Actually... this is better... it avoids the #VALUE! error if both fields blank.... and looks better.

Please Login or Register  to view this content.

[daddylonglegs]

Here's another way.....

=IF(COUNT(D5790,F5790)=2,MOD(F5790-D5790,1)*1440,"")