# 01/01/1900

1. ### 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. ### 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. ### 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. ### 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. ### 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...