Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculate total service time in excel | Excel Discussion (Misc queries) | |||
How do I add a duration time value and a clock time value? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Total TIme worked | Excel Worksheet Functions | |||
unmet challenge | Excel Worksheet Functions |