Time clock total issue

[madpeyjag]

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.

 

[Niek Otten]

To display times over 24H; Format Custom as [h]:mm
For overtime:

http://www.cpearson.com/excel/overtime.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
|
|