Team,
Sorry I am just out of it today. I have been sitting here for over an hour trying to figure this out and I have done it before, I just think today isnt the day for me to be working.
I need a formula to figure hours worked per week.
I have the first day set up on line 15 as =SUM(D15-C15)*24-0.5,, but that only calculates the 1st day and then I am just stuck as to how to add the rest of the week.
Thanks for any and all help!
Which XL version?
My bad, I knew I was forgetting something, today just isnt my day.
Excel 2010 is what I am using.
Thank you,
Pl see the attached file.
Last edited by kvsrinivasamurthy; 09-14-2013 at 01:08 PM.
Thank you very much. I have to deduct 30 min a day for lunch breaks. This helps big time, and I had it all wrong also.Originally Posted by kvsrinivasamurthy
Thanks
Shorter..
=IFERROR(MAX((D8+F8+H8+J8+L8+N8+P8)-(C8+E8+G8+I8+K8+M8+O8)-TIMEVALUE("0:30")*(COUNTA(C8:P8)/2),0),"")
format cell as [h]:mm:ss;;
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks