Build me an online attendance system using google sheet

The system must:
1. record time in, time out and lunch hour
2. auto count working hour
3. punching using bar code
4. only can punch in store
5. avoid other person punch for another person