Total Hour Calculation

[alamgiritbd]

=IF(B14="",B14,IF(B14>0,"10:00"))

When b14 have any value >then 0 then in m14 show 10:00. And format cell is [hh]:mm.

That formula on cell M14 to M44.


The problem is that i need total hour on m46. I try sum, subtotal but it show 00:00 or wrong value.


Thanks

 

[xld]

Format M46 as [h]:mm as well.

 

[alamgiritbd]

It's not working.

0:00

 

[xld]

The problem is that M46 is trying to sum text values, change M14 (and the rest) to


=IF(B14="",B14,IF(B14>0,--"10:00"))

 

[alamgiritbd]

Thanks.....