Home · Maps · About
Home > SubChat
 

[ Read Responses | Post a New Response | Return to the Index ]
[ First in Thread | Next in Thread ]

 

view flat

Re: Excel

Posted by Bill West on Wed Dec 6 03:35:16 2017, in response to Excel, posted by BusRider on Tue Dec 5 23:00:41 2017.

I'll give it a go. While dates are displayed in a readable format they are processed as a day number starting from 1900 or 1904 and time as a decimal fraction of a 24 hour day. Formatting a date or time cell as a decimal number will reveal this. Make sure the column width is enough when you are looking in date format.

So an IF formula will compare the dates as if they are just a number. If you are comparing a date with a time against another you need to sum the 2 parts for the IF statement. December 6, 2017 and 6am added together is 43075.25 and December 7, 2017 9pm is 43076.75. IF((D1+T1)<(D2+T2),"is earlier","is later") will work.

If that's not enough, post your problem.

Bill

Responses

Post a New Response

Your Handle:

Your Password:

E-Mail Address:

Subject:

Message:



Before posting.. think twice!


[ Return to the Message Index ]