• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Total Hour Calculation

alamgiritbd

New Member
=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
 
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"))
 
Back
Top