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

    Sunday Dates

    file upload
  2. F

    Sunday Dates

    i want to add sundays & holidays dates in excel & add 1 in this result.
  3. F

    Date and Time Formula

    thanks
  4. F

    Date and Time Formula

    Faseeh basically we have date in this format " 22-01-2013 10:02:32 AM"It means it is a true date with time format
  5. F

    Date and Time Formula

    I have a date in a cell in given format " 22-01-2013" I need an out put in next cell which shows the date after 72 hours . Kindly tell the formula
  6. F

    Convert PDF into Excel

    i have converted the file from pdf to word and then trying to import it in Excel by using option Get external data from text option ,the window appear next ask 2 options Fixed or delimited but in both cases "text "of file change in different sign.Can i fix it ?
  7. F

    Convert PDF into Excel

    Thanks bobhc . Kindly mention the steps of converting the procedure to import word data into excel . i use the function form Get extrnal data ( from text ) but it does not work after appearing screen of "txt import wizard"
  8. F

    Convert PDF into Excel

    Dear I have received the following message while converting the pdf doc into excel " Your file conversion failed! File name: tmr pdf.xls Message: Your document did not contain any tables that could be converted to Excel." is there any way to fix this problem ?
  9. F

    Calaculate time

    thanks it works
  10. F

    Calaculate time

    Dear All Convert formula of above mentioned query is not compatible with office 2003. Kindly update me how can use the same formula in office 2003.
  11. F

    Calaculate time

    Thanks it works u people are great
  12. F

    Calaculate time

    I have maintained a Machine maintenance sheet in excel in following format and use the formula given below.We need to convert minute into hours and the formula is =Time(0,Sum(Range1:Range2),0) answer is correct till 1439 minutes and it shows that total breakdown period is 23 min and 59 sec...
  13. F

    PivotTable refresh issue

    I have tried to refresh the data but not succeed . i have a data sheet containing field date , company name amount . using pivot table function a new sheet create shows name of companies in row and month and amount in column like company 1 company 2 Jan 1000...
  14. F

    Conditional Formating

    thanks u r great
  15. F

    Conditional Formating

    Multiple conditional formatting work fine can we apply conditional formation on more then two conditions assuming highlight all the id ( col a) the manager ( col B ) of Accounts department col ( c)
  16. F

    Conditional Formating

    Hurray It works thanks a lot
  17. F

    Conditional Formating

    Hurray It works thanks a lot
  18. F

    Conditional Formating

    I have a data containing two columns empid and emp desg .My requirement is to highlight the empid based on emp designation .for instance i need all the account managers id highlighted .
Back
Top