minus

It's been a while since I've had to use SQL and that was Oracle. Basically I have two tables and I want to just display the items from table a that aren't in table b. Below are the methods of how I thought you would do it, but it doesn't bring in the right results. (The fields are all...

Hello, We have a spreadsheet where, instead of adding (SUM) or multiplying (SUMPRODUCT) we want to subtract each item. Preferably we'd like to do this in a pivot table. i.e. Data is: Item Value X -10 X -30 X -20 So, we'd want the value to be -10 - (-30) - (-20) =...

Hi, I've got some lists of times in hours minutes and seconds for programme transcripts starting at a random number, for example one of my lists starts at 22 minutes and 30 seconds and then will have different time codes randomly for between 25 and 45 minutes. I need to minus the first value so...

Hi all<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a spreadsheet with dates people started the company I need to figure out if they have been here over a year. In have tried several different ways and have figured out a few long...