View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
madpeyjag madpeyjag is offline
external usenet poster
 
Posts: 3
Default Time clock total issue

I have a timeclock I setup with help from a previous post, but I can't get
the total to calculate over 24 hrs, let alone 40 hrs. Since I work from home,
I have it where I can clock in and out 3 times. This is a 2 week timeclock.

Here is my formula for each day:
=SUM((B12-B11)+(B14-B13)+(B16-B15))+24

Here is my total fo the week:
=SUM(B17:H17)+24

I also need to calculate the overtime hrs for each week in a separate cell.

Thanks for any help with this.