Enclosed is an excel file.
This file has two cols of data. ColA and ColB.
ColA has two dates in it...one in row1 and one in row4. If you check to see if the dates in A1 and A4 are equal (see cell A6) you will see that they are not. Its not until you format colA as a number that you see the "last" number is diff between A1 and A4. But if you format colA as a date with time ....they appear equal.........so why arent the numbers equal?
Has one of these dates been calculated? Look:
AliGW on MS365 Beta Channel (Windows 11) 64 bit
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
as numbers
A1=44215.3661342593
A4==44215.3661362269
Hence the FALSE result which reflected how Excel holds dates as floating-point numbers
Formatting cells as dd/mm/yyyy hh:mm.ss.000 (000= milliseconds) will show the difference.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
hi all,
when i format the cells per your suggestion i still see no difference. even the seconds in mine are exactly the same. so i must be doing something wrong.
The table in my post is taken from YOUR file! Did you increase the number of decimal places to see the issue?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks