billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Good morning All
Actually viewed this subject in a recent Post. Attempting to understand why the Int Function returns a value error from a cell. I believe it has something to do with the dates not in English format.
The cells with the error are from 16/01/2017 11:30 and down.
<tbody>
</tbody>
Example
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Actually viewed this subject in a recent Post. Attempting to understand why the Int Function returns a value error from a cell. I believe it has something to do with the dates not in English format.
The cells with the error are from 16/01/2017 11:30 and down.
Thanks |
<tbody>
</tbody>
Example
Order | Date | Item |
3168-5252 | 2/1/2017 9:30 | 448 |
3168-5252 | 2/1/2017 9:30 | 448 |
3321-5464 | 2/1/2017 10:30 | 441 |
3412-5611 | 2/1/2017 10:30 | 508 |
3412-5612 | 2/1/2017 10:30 | 508 |
3412-5612 | 2/1/2017 10:30 | 508 |
3412-5612 | 2/1/2017 10:30 | 508 |
3396-5585 | 2/1/2017 11:00 | 631 |
3396-5586 | 2/1/2017 11:00 | 631 |
3396-5586 | 2/1/2017 11:00 | 631 |
3519-5777 | 16/01/2017 11:30 | 239 |
3339-5498 | 16/01/2017 12:00 | 157 |
3541-5811 | 16/01/2017 12:30 | 508 |
3541-5812 | 16/01/2017 12:30 | 508 |
3541-5812 | 16/01/2017 12:30 | 508 |
3541-5812 | 16/01/2017 12:30 | 508 |
3541-5812 | 16/01/2017 12:30 | 508 |
3541-5812 | 16/01/2017 12:30 | 508 |
3495-5744 | 16/01/2017 14:10 | 448 |
3547-5819 | 16/01/2017 14:30 | 731 |
3548-5820 | 16/01/2017 14:30 | 732 |
3555-5829 | 17/02/2017 09:30 | 545 |
3567-5847 | 17/02/2017 10:30 | 255 |
3567-5848 | 17/02/2017 10:30 | 255 |
3567-5848 | 17/02/2017 10:30 | 508 |
3567-5848 | 17/01/2017 10:30 | 509 |
3567-5848 | 17/02/2017 10:30 | 255 |
3458-5683 | 17/02/2017 13:00 | 523 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>