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!
|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|
|Stuart||04/16/16||10||10||10||Worked like a charm, many thanks Aidan .....|
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
I tend to use Pivot Tables to sum such data, but excel has no problem with a SumIfs with a date - it's jus that you have to remember that a date is simply a number - so =SUMIFS(D2:D21,A2:A21,"Bill"
a little messy I'm afraid =OFFSET(OFFSET($A$2,0,MATCH(Sheet1!C7,$B$2:$E$2,0)),MATCH(VLOOKUP(Sheet1!E7,OFFSET($A$2:$A$9,0,MATCH(Sheet1!C7,$B$2:$E$2,0)),1,TRUE),OFFSET($A$2:$A$9,0,MATCH(Sheet1!C7,$B$2:$E$2
This is a very subjective question I imagine - I'm not a scientist, so having the periodic table available would be of no use to me - but possibly to others it would be of use - should you need one, http://www
At a simplistic level, https://1drv.ms/x/s!AhG5Rd-eb4P3v0Roxw09IKFcSDmr would give you what you need - I've NOT used the region at the moment, but you can probably get the idea of how this works. To work
Answers by Expert: