Recent content by Keith Nichols

G'day DataCruncher, I have had a 20 minute play with this and can see that it gets horrible when I try to sort the rows by repetetive Min and Max functions and ifs. Way too complicated. Without dedicating any more time to thinking about this, I think that you should be able import the...

Clumsy way but might be enough Rhet, If you can copy both spreadsheets into a single book, it is pretty straightforward to do a comparison of one worksheet with another. The formula below in A1 of a third sheet will show if the cells A1 in the other 2 sheets have the same contents or the...

Small problem with times over 1 hour Hi Holger, The formula =(INT(G87/60) & MOD(G87,60))*1 displays the correct formatted results as long as the minutes do not fall in the ranges 60-69, 120-129, 180-189, etc. ie. when the modulus is under 10. To get round this problem I have added a logical...

Thanks Holger.

Marvelous HoHeBo, Thanks, works a treat. :D The times I'm recording are my exercise time and the actual start finish is irrelevant, just the duration is of interest. This is also what comes of my Polar heart rate recorder watch and to use time, I would have to work it out every time. Not a...

Hi, I am trying to sum time in minutes and display the result as hh:mm but getting all sorts of problems as the minutes always seem to be related to a date rather than just numbers. Here is the sort of thing I want: Time Day 00:55 Mon 00:25 Tue 01:20 Wed 00:30 Thur 00:30 Fri...

SJ, Good news. Some of the craaaaap (I'm talking about the spam - :) ) being posted was getting to be offensive, even to an old porn lover such as myself (there are times and places etc). Do you reccomend that we (I) keep using the red triangle to flag this turgid nonesense as soon as we see...

Hi Colin, Firstly, I wasn't getting at you as such: as a rank amateur, I must say that you post frequently and seem to be pretty good to my inexperienced eyes (and (I think) to those more experienced with more experienced eyes than mine!). I don't know the exact set up of a board like this...

Having worked in a middle eastern country (Arabs) and knowing that (although the Iranians classify themselves as something something other than Arabs) the Iranians are broadly similar, I can tstify that their nuclear ambitions can only be a threat to themselves. Either by invitng attack or just...

From over the waters, it is very difficult for Brits and other Western 'democracy' types to distinguish between the US Left and Right. The appear mostly right and very right, in the wrong kind of way. I add the caveat as I am not a lefty as such, although I have a tender heart, but mostly I'm...

A bit harsh Colin? Moderators are volunteers who give their time freely. They can only be expected to do so much. From other threads it appears that some moderators have approached 'John' to get the rights required to put in place spome basic screening of posters etc which would reduce the spam...

If I have understood the question correctly, is there some reason you cannot use DoCmd.Maximize? I think this should work unless you are looking to only maximize in one dimensions (horizontal or vertical). There are methods of measuring the window dimmensions and using them to size your form or...

Dreamweaver, That sounds a lot more reasonable and it does appear that both employer and employee are appreciated where you work. Congrats on the recent promotion. I guess the only issue left is should your employer pay you extra for a none-core activity when your a self confessed 'hobby DB...

These staircases also typically have irregular rise and step distances. Negotiatng the staircase backwards whilst fighting, one finds your next step with your heel (try being on the 'light end' of something heavy that you are moving from the downstairs to the upstairs and you wil see what I...

I have been charecterized by many over the years, mostly not flattering but usually funny. Examples are ("I am" substituted for "He is" or "You are"): ...from the shallow end of the gene pool. ...slow, but I am rough. I'm sure many more will come to me over the next few days. But now, I...