Search results

It works for me with the examples you gave

Dear Kashyap Barot, My mistake, obviously I've have drunk to much already! :rolleyes:

May be one of these others then? http://peltiertech.com/WordPress/trellis-plot-alternative-to-stacked-bar-chart/

Hi, In your spreadsheet all your values are TEXT, so does this work for you? =VALUE(A2-B2) copy down and format the cells to [h]:mm

Something like this? http://chandoo.org/wp/2009/12/02/group-small-slices-in-pie-charts/

Hi, Take a look here it might help? http://chandoo.org/wp/tag/in-cell-charting/

Can you please upload a file for a better understanding, with your expected result?

Hi malbarki, Going on your first example Try this =IF(A1>=B1,A1-B1,"-"&TEXT((B1-A1),"hh:mm")) and copy down, this will give any negative time values as TEXT all the others will be NUMERIC BTW - I get -3:24 in Ex.2, don't know how you arrive at -2:36?

Thank you and a very Happy Christmas to you too Kanti ;)

Hi Kashyap Barot, If you split the time values from the date with =MOD(A1,INT(A1)) copy down Then use =AVERAGE(IF(B1:B13<>0,B1:B13)) Entered as an array Ctrl+Shft+Enter and format to time

Here's some more reading here http://www.xldynamic.com/source/xld.Rounding.html

Hi malbarki, Try this =B2-A2+(B2+1-B2)

Hi Ram, I'm still trying to understand your requirement, but try this to get all the numbers begining with 100. Put header in A1 called Numbers and in A2 Sorted Numbers, then in B2 put ="-"&A2 and copy down Select your range columns A:B, Filter, then on the B filter, Begins with .... -100 > OK...

Hi, Welcome to the forum, if you want some reading over Christmas take a look at this article by Hui... it may help? http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/

If you copy the formula downwards you will get the results you require

Hi, Do you mean a new tab for your Help file? Maybe this could help?

@SirJB7 I'm glad you explained, I did wonder :eek:

This is getting to be a habit - well done :DD on reaching 7000

Hi Ram, Use a Custom Filter like so

Hi Ram, Welcome to the forum, please try this in D3 and copy down =(C3-B3+1)/100

Hi Jamir, The vlookup that ismailzhan suggests does the job, but is the "15 times" a maximum you can have? If it is then you will need some data validation on the "Inv No" to restrict entries to a maximum of 15.

Hi Chandoo, Yes, thank you I missed that one, I've now set it up - thanks

Hi, Check to see if the path of the file in your Personal macro has changed?

Hi Chandoo, Thanks for the improvments. Can I suggest another? When I answer or comment on a question I forget to click the "Watch this Tread" icon at the top of the screen, so once I've posted my reply I have to open the question up again and click the Watch icon. Could that little icon be in...

Hi Pooja, I see you are a new member, I hope you have had chance to read these? http://chandoo.org/forum/forums/new-users-please-start-here.14/ With regard to your question take a look at this link here, it may help, if not upload a file http://chandoo.org/wp/2012/05/22/highlight-due-dates-excel/