Spreadsheet: 525279d1498656498-need-help-in-my-time-sheet-count-if-9hrs-worked-then-calculate-as-1-day-working-time-table-estevaoba
Sheet: Time Sheet

Monthly Employee Time Sheet
 |  |  |  |  |  |  | 2017 |  |  | Month: |  | 6
 |  |  |  |  |  |  | 2017-06-01 00:00:00
[Company Name] |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa
 |  |  |  | Employee Name |  |  |  |  |  |  | 2017-06-01 00:00:00 | 2017-06-02 00:00:00 | 2017-06-03 00:00:00
[Address 1] |  |  |  |  |  |  | 2017-06-04 00:00:00 | 2017-06-05 00:00:00 | 2017-06-06 00:00:00 | 2017-06-07 00:00:00 | 2017-06-08 00:00:00 | 2017-06-09 00:00:00 | 2017-06-10 00:00:00
[Address 2] |  |  |  | Employee Code - Dept |  |  | 2017-06-11 00:00:00 | 2017-06-12 00:00:00 | 2017-06-13 00:00:00 | 2017-06-14 00:00:00 | 2017-06-15 00:00:00 | 2017-06-16 00:00:00 | 2017-06-17 00:00:00
[City, State  ZIP] |  |  |  |  |  |  | 2017-06-18 00:00:00 | 2017-06-19 00:00:00 | 2017-06-20 00:00:00 | 2017-06-21 00:00:00 | 2017-06-22 00:00:00 | 2017-06-23 00:00:00 | 2017-06-24 00:00:00
[Phone] |  |  |  | Month | 2017-07-01 00:00:00 |  | 2017-06-25 00:00:00 | 2017-06-26 00:00:00 | 2017-06-27 00:00:00 | 2017-06-28 00:00:00 | 2017-06-29 00:00:00 | 2017-06-30 00:00:00
Day of Week | Time In | Time Out | Total Hrs | Work days | Overtime Hrs |  | Day of Week | Time In | Time Out | Total Hrs | Work days | Overtime Hrs
2017-07-01 00:00:00 | 06:00:00 | 15:30:00 | 9.5 | 1 | 0.5 |  | 2017-07-16 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-02 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-17 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-03 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-18 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-04 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-19 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-05 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-20 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-06 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-21 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-07 00:00:00 | 06:00:00 | 11:00:00 | 5 | 0.5 | 0 |  | 2017-07-22 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-08 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-23 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-09 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-24 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-10 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-25 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-11 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-26 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3
2017-07-12 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-27 00:00:00 | 06:00:00 | 12:00:00 | 6 | 0.5 | 0
2017-07-13 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-28 00:00:00 | 09:00:00 | 18:00:00 | 9 | 1 | 0
2017-07-14 00:00:00 | 06:00:00 | 18:00:00 | 12 | 1 | 3 |  | 2017-07-29 00:00:00 | 09:00:00 | 18:00:00 | 9 | 1 | 0
2017-07-15 00:00:00 |  |  | 0 | 0 | 0 |  | 2017-07-30 00:00:00 |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | 2017-07-31 00:00:00 |  |  | 0 | 0 | 0
Regular hours |  | 9
[NAME] |  |  | 10000
Total Days Worked |  |  | 27 |  | Want to Calculate if an employee works for 9 hrs then its should calculate as 1 day and if he works for 5 hrs then 0.5 day
Over Time |  |  | 69.5 |  | Over time should calculate only if worked for 9hrs over ignore the -values.
Actual pay