• 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.

Search results

  1. H

    Sumif with time HH:MM - not working right

    Dear All Thank you for the welcome and for the three kind suggestions. I went through in order, and luckily [h]:mm did it (Big respects to Hui-san - can't be helped guys - he is the ninja!) I've seen this before but completely forgotten about it - its for when times go over 24 hours right...
  2. H

    Sumif with time HH:MM - not working right

    I am using sumif all the time with pounds - I have to use with time but the results aren't right... its timesheets time: Sheet 1 [Column A] multiple duplicate staff names (format text) [Column B] Start time (format hh:mm) [Column C] End time (format hh:mm) [Column D] =C-B for total...
Back
Top