Recent content by XerxesDGreat

  1. X

    calculate difference between two times?

    (looks for "oops, I'm embarrassed" smiley...) I don't know about 2007, but mine doesn't. Perhaps doing my homework a bit more before posting would be a good thing... I was right about the rest of it, tho! ;)
  2. X

    Conditional Formatting after AutoFilter

    Sheer genius! It works just as promised, though I took the liberty of taking off the two minus signs; not sure if they're necessary for something, but it works just fine without them. Thank you very much!
  3. X

    calculate difference between two times?

    Use either the "Date" or the "Time" datatype, depending on what you're looking for, to record the time. If you're only concerned with days, "Date" is better. Likewise, if you're after hours, minutes, and seconds, use "Time" (although, unless I'm mistaken, time will store the date as well)...
  4. X

    Conditional Formatting after AutoFilter

    I'm developing a price list where I import an inventory list from our POS software, do a couple manipulations, and paste it into an import sheet from which I pull information to propagate the worksheet. My goal is to make this a one-operation deal, i.e. paste the inventory list to the import...
Back
Top Bottom