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

    talk hour formatting to insert a pivot table

    hey , i resolved the issue thanks all
  2. U

    talk hour formatting to insert a pivot table

    Hi, I have got talk hour data of executives month wise,.(extracted from a reported generated by a our daily use software) It appears as hh:mm:ss ., but when we click on single cell, we find that it is concactnated with date and some time. this format, we are unable to remove by any type of...
  3. U

    No. of days lapsed from a gvien date

    Hi Nazmul, I just tried minus formula of two cells and dragged it down. But your formula also seems to be working. Thanks a lot, Ushasri
  4. U

    No. of days lapsed from a gvien date

    Hi Hui, sorry about quickly asking a question. I solved the issue. NO worries now. Thanks Ushasri
  5. U

    No. of days lapsed from a gvien date

    Hi Hui, I tried your suggestion, the result of the formula displays ########### saying dates and times too large or negative ; manual calculation says it is only above 90 days i am calculating...... for first cell. Drop down seems impossible here suggest if there could be a mistake in...
  6. U

    No. of days lapsed from a gvien date

    Yes, the formula worked as I said, but it can't be dragged down the column. considering the example below: It is as simple as =Date2-Date1 Assume: A1 has 1/6/2012 A2 has =Today() A3=A2-A1 = 38 (for today only) A1 is different in each row.How to make the formula consider a different...
  7. U

    No. of days lapsed from a gvien date

    actually your suggestion works for one cell, but not for an entire column. Should there be a modification in formula? Please suggest . Thanks.
  8. U

    No. of days lapsed from a gvien date

    Hi, Can some one suggest, how to obtain the number of days passed till today or (given date) from a given date . Any formula? thanks
  9. U

    Short date function

    =TEXT(A1,"DD/MMM/YY") The above formula worked. Other two did not. Thanks all.
  10. U

    Short date function

    Creadted Date 2012-04-12 21:05:12 2012-03-29 18:36:29 I want to remove the time from each row . Ex. is given above, can someone help.
  11. U

    Force upper case

    sorry..here is the correct one =upper(columnname) example =upper(A1)
  12. U

    Force upper case

    =uppercolumn name) like =upper9A1) This formula should work
  13. U

    Short date

    Thanks for replying. I have a report generated from website which throws a column, "created date". This column has date and time adjacent to it. I remember clicking on "shortdate" to remove the time from each row of the column. now it doesn't seem to operate. Tried taking data on fresh...
  14. U

    Short date

    What if excel worksheet doesnot accept short date command. Tried taking the data in new sheet also. Short date does not function.
Back
Top