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

    Extracting Hours

    Hi All, The Formula given by Faseeh Worked. It Gave what I wanted. Thanks Everyone!
  2. S

    Extracting Hours

    Hi Hui, Thanks for replying & welcoming me to the Forum. When I tried using the formula you have suggested, the following happens: A1 = 34:02:04 (The formula bar shows: 1/1/1900 10:02:04 AM) - got from data dump B1 = INT(A1*24)/24 gives me 10:00:00 But, I want the B1 value to be...
  3. S

    Extracting Hours

    Hi, I have a column named "Elapsed Open Time' and the data is in the format HH:MM:SS. The HH is not restricted to max limit of 24. So, a sample data is "34:20:12" meaning the particular record is 34 hours 20 min and 12 seconds old. I need to extract the HH value alone(in this case, only...
Back
Top