| intime | outtime |
| 08:45 | 18:11 |
| 08:30 | 20:15 |
if datediff(hour,'08:45','20:15') hour difference 4 or 5 means put /
if hour difference 7 or 8 (between 7 and 8) means X
greater than 11 means X/
| intime | outtime |
| 08:45 | 18:11 |
| 08:30 | 20:15 |
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Nitin SontakkePosted Apr 5, 2017, 6:18 AM
Asma KhalidPosted Apr 5, 2017, 6:06 AM