Prev Previous Post   Next Post Next
  #1   Report Post  
S.E.
 
Posts: n/a
Default Time Sheet

I'm having an issue trying to find a formula that will work for the task I'm
trying to complete. I've created an Excel Spreadsheet...broken down into
Date columns, and the rows consist of "Time In, Time out, Time In, Time Out."
What I'm trying to do is at the end of every column have the time added up
and totaled, not including that middle timeout-timein (lunch period). For
each of the days of the week, then at the very end of the row that has the
daily total hours, I want to calculate the entire weeks total hours worked.
What formula's should I use to make this work?

Help!
 
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
Formula to deduct unpaid breaks in time sheet Rick Excel Discussion (Misc queries) 3 August 26th 05 11:53 PM
time sheet calculations emmcee Excel Worksheet Functions 7 August 20th 05 12:26 PM
Excel formula for a time sheet HRMSN Excel Worksheet Functions 1 August 10th 05 03:07 PM
Time Sheet calculations dkostel Excel Worksheet Functions 2 November 23rd 04 10:11 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 11:13 PM.

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"