INT conversion of time is giving me an erroneous result

Quick update:

I completed that row, and started on the 2nd row which had:

Col1: 02:04:00
Col2: 02:10:00

But the result in Col 3: 5!!!!!

If you change the 10 in Col2 to 11, Col 3 result: 6
If you change the 11 in Col2 to 12, Col 3 result: 7
If you change the 12 in Col2 to 13, Col 3 result: 8
If you change the 13 in Col2 to 14, Col 3 result: 9
If you change the 14 in Col2 to 15, Col 3 result: 11 !?!?!

I'm not sure what's going on...

FearNix

Attaching this simple beginning as I haven't really got far. It will eventually have sheets/tabs for each casino or poker site, and will have more columns when I get to grips with more information as I start gathering.

Hope it helps.

FearNix

Originally Posted by FearNix

I completed that row, and started on the 2nd row which had:

Col1: 02:04:00
Col2: 02:10:00

But the result in Col 3: 5!!!!!

Just because you see the time difference as 6 minutes does not mean that is how Excel sees it. Time in Excel (and VBA as well) is a fraction of a 24-hour day. Rarely is that fraction exact. In the case above, the actual calculated answer is 5.999999999999976 which Excel "helpfully" rounds to 6 when it attempts to show it with 10 digits, however the INT function is actually chopping off everything after the decimal point for the actual underlying value, not the displayed value. As with most calculations involving floating point number, it is better to use the ROUND function rather than the INT function. If you change your formula to this...

=ROUND((B1-A1)*1440,0)

You will consistently get the values you expect.