LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate total service time in excel VCW Excel Discussion (Misc queries) 1 August 2nd 06 10:10 PM
How do I add a duration time value and a clock time value? sueb262 Excel Worksheet Functions 3 July 16th 06 10:45 PM
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 10:30 PM
Total TIme worked jlogan21 Excel Worksheet Functions 2 January 4th 06 07:02 PM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM


All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"