01/01/1900

  1. L

    adding 1 to a time (cross mid night)

    Hi I was watching a video on how to subtract 1:00 am from 11:00 pm (cross midnight). So the author added 1 to the am time and then subtract it from 11:00 pm. Before adding 1 to 1:00 am, if I click on that cell I see in the formula bar 1:00:00 AM when I add 1, see 01/01/1900 1:00:00 AM...
  2. L

    double click a cell with time as a value

    Hi I have a cell D4 which has value = 40:03:28 The value is aligned to the right side of the cell, which gives me an impression it is a number, right? When I one click (select) that cell. I see the following: cell value = 40:03:28 Formula bar = 40:03:28 Home tab-->Number group --> I see...
  3. E

    Formula Returning 0

    Hi, Could I please ask for some help on a formula that works fine except when there is nothing to return =IFERROR(LOOKUP(2,1/(Update!$FL$3:$FL$5002=$B$1900)/(Update!$FO$3:$FO$5002=C1903),(Update!$FU$3:$FU$5002)),"") Unfortunately when B1900 and C1903 is blank this formula returns a date...
  4. M

    compare two column each other

    hi all: i comparing two table with formula: serial and Lot i used this formula: =IF(H2=0,IF(C2=I2,"match","not match"),VLOOKUP(H2,$B$2:$B$21,2,0)) column can be assumed as excel file. vlookup paste value, i want paste match or not match. kindly tell me is it possible with formula. i am using...
  5. S

    Calculating Min Value from a Series of Unique Values......

    I have a series of data (c. 200k rows) with a sample below, and I'm after a formula that will give me the Min value for Start Date for each unique Item ID. I have used a formula (=days(today(),[Start-Date]) to calculate the days, but how do I identify only the min value for each of the SKUs...

Some videos you may like

This Week's Hot Topics

Top