formula calculation gets wrong - using Minute formula

[VBABEGINER]

Dear All,
Need one help for below example

A1 = hours workd B1 = Stand hours

A2 = 8.50 B2 = 7.24
A3 = 5.50 B3 = 7.24

C2 = 26.00
C3 = #NUM !

Why error on C3 cell...can anyone help

 

[RoryA]

Perhaps you could tell us what formula is in C3?

 

[offthelip]

it is because the function minute only works with positive numbers, 8 hours 50 minute minus 7 hours 24 minutes give a positive time value, while 5 hours 50 minutes minus 7 hours 24 minutes gives you a negative time value, time cannot be negative. so depend what result you wnat as to how to solve the problem

 

[VBABEGINER]

=MINUTE(A3-B3)

silly mistake..

 

[RoryA]

Do you really want 26 rather than 86 as the result for C2? Do you not care about the hours part?

 

[VBABEGINER]

Ohh...is that the wrong answer...
I want to use minute function...first time using minute formula..
Help in guide the same..

Do you really want 26 rather than 86 as the result for C2? Do you not care about the hours part?

 

[RoryA]

Since there are 1440 minutes in a day, you could use:

=(A3-B3)*1440

 

[VBABEGINER]

Since there are 1440 minutes in a day, you could use:

=(A3-B3)*1440

Ohhh..Thats correct.I did not calculate min in my output..
Super..Thanks for showing this..This helps..

 

[VBABEGINER]

with this formula I have one more requirement..
suppose,
"IF the value in cell A1 is BLANK, then return "BLANK""
"IF the value in cell A1 is TEXT, then return "TEXT""
"IF the value in cell A1 is NUMERIC, then return "NUM""

How do I use formula for this..

 

[RoryA]

That's a completely different formula.

=if(a1="","BLANK",IF(ISNUMBER(A1),"NUM","TEXT"))