#### SarahM1985

##### New Member

- Joined
- Mar 27, 2018

- Messages
- 3

Details...

- Monday - Friday Work Week
- 1 hour unpaid lunch
- Need to keep track of total hours for week (in 60 minute formula not 100) Example: need it to say 7:50 instead of 7.83
- Also, Since she is temp, her contract is for 720 hours before she can be hired on. I need to keep track of how many hours she has left.

What I have so far...

- Col A is Date Worked
- Col B is Time In
- Col C is Time Out
- Col D is Days Total (how many hours she worked that day
- Col E is Weeks Total
- Col F will reflect the 720 (preferable counting down. I.E. showing how many hours she has left)

- Col B and Col C is formatted in "Custom" H:mm
- Col D, I have the =24*(C2-B2+(C2>B2))-1

Col D is currently formatted as General, but I have tried Number (2 Decimal) and also the "Custom" h:mm (h:mm, for some reason, takes away my calculations and D2 goes to 0:00 and D3 goes to 20;00)

I do not have the formula for Col E or F yet, since I was distracted by D