Formula shows hrs and min

[asyamonique]

Hello All,
How can I avoid that formula shows "0hrs 0min" if there is nothing on cell CY3?

=IF(SUM(CY3)>=0,"","-")&INT(ABS(SUM(CY3))/60)&"hrs "&MINUTE(ABS(SUM(CY3))/1440)&"min"

Thanks

 

[Fluff]

How about

=IF(CY3=0,"",INT(ABS(SUM(CY3))/60)&"hrs "&MINUTE(ABS(SUM(CY3))/1440)&"min")

 

[rlv01]

Why are you using SUM(CY3) instead of just CY3?

 

[asyamonique]

Why are you using SUM(CY3) instead of just CY3?

Actualy I was using for CN3:CY3 datas which exported as minutes, bu no longer using that ranges so I've just placed as CY3 only.
Now on CY3 I have another formula

=IFERROR(VLOOKUP(CA3,AW:BS,22,0),"")

Any suggestions?

 

[Fluff]

In that case how about

=IF(CY3="","",INT(ABS(SUM(CY3))/60)&"hrs "&MINUTE(ABS(SUM(CY3))/1440)&"min")