I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards. I'm based in the UK, so please allow for time differences when asking me questions from other parts of the world!
My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.
I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!
|Chris||11/03/16||10||10||10||Fantastic! Aidan Heritage is THE MAN! Thank .....|
|Malcolm||09/22/16||10||10||10||Thanks Aidan for youur quick and clear .....|
|Prashant S Akerkar||09/03/16||10||10||10||Dear Aidan Thanks. Prashant|
Good to hear from you again - Excel treats numbers and text as different things - and although it is kind to you by allowing you to manipulate the number 581 as a string, the value 5 that it returns isn't
I'm afraid you've just repeated the question in slightly different words. Without a worked example I fear I'm not going to be able to help - if D = A/B then D cannot be .5 in your examples - if you are
I'm afraid I don't understand the logic of the question, as your example wants C to be filled, but the formula makes no use of C - if you can clarify I am happy to help further - if an example sheet would
This is one of those "I don't think I'd have done it that way" questions, in that by having all the data on one tab, it would PROBABLY be easier to summarise - I would be inclined to summarise using pivot
I'd probably do this with a lookup table due to the number of possibles, but the rules aren't quite clear as you've shown what appears to be 4 hours 25 minutes and 40 seconds as being less than 2 hours
Answers by Expert: