Time Sheet - Calculating Time Differences for Totals

I have a time sheet with four fields:
Time In (C2),  Lunch Out (D2),  Lunch In (E2),  Time Out (F2)
I'm trying to create a formula in cell G2 to calculate the regular hours and 
another formula in H2 for the overtime hours, but have been unsuccessful.  
Current fields are formatted as Number | Custom | h:mm AM/PM for C2 thru F2 
and are formatted as Number | Custom | h:mm for G2 and H2.

Can anyone help me.
1
Utf
1/14/2010 3:42:01 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
1028 Views

Similar Articles

[PageSpeed] 48

Hi,
Look into CPearson Web it has all the working with overtime Hs

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



"Kathy" wrote:

> I have a time sheet with four fields:
> Time In (C2),  Lunch Out (D2),  Lunch In (E2),  Time Out (F2)
> I'm trying to create a formula in cell G2 to calculate the regular hours and 
> another formula in H2 for the overtime hours, but have been unsuccessful.  
> Current fields are formatted as Number | Custom | h:mm AM/PM for C2 thru F2 
> and are formatted as Number | Custom | h:mm for G2 and H2.
> 
> Can anyone help me.
0
Utf
1/14/2010 3:45:01 PM
Thanks for the help!


"Eduardo" wrote:

> Hi,
> Look into CPearson Web it has all the working with overtime Hs
> 
> http://www.cpearson.com/excel/overtime.htm
> 
> 
> 
> "Kathy" wrote:
> 
> > I have a time sheet with four fields:
> > Time In (C2),  Lunch Out (D2),  Lunch In (E2),  Time Out (F2)
> > I'm trying to create a formula in cell G2 to calculate the regular hours and 
> > another formula in H2 for the overtime hours, but have been unsuccessful.  
> > Current fields are formatted as Number | Custom | h:mm AM/PM for C2 thru F2 
> > and are formatted as Number | Custom | h:mm for G2 and H2.
> > 
> > Can anyone help me.
0
Utf
1/14/2010 4:36:01 PM
This was a great help to me.  The only problem I'm having now is that I want 
to total the column of regular hours, but it's not coming up to the correct 
total.  I've tried to just use the sum function, but that's not bringing up 
the right total.  Any suggestions?


"Eduardo" wrote:

> Hi,
> Look into CPearson Web it has all the working with overtime Hs
> 
> http://www.cpearson.com/excel/overtime.htm
> 
> 
> 
> "Kathy" wrote:
> 
> > I have a time sheet with four fields:
> > Time In (C2),  Lunch Out (D2),  Lunch In (E2),  Time Out (F2)
> > I'm trying to create a formula in cell G2 to calculate the regular hours and 
> > another formula in H2 for the overtime hours, but have been unsuccessful.  
> > Current fields are formatted as Number | Custom | h:mm AM/PM for C2 thru F2 
> > and are formatted as Number | Custom | h:mm for G2 and H2.
> > 
> > Can anyone help me.
0
Utf
1/14/2010 10:04:02 PM
Reply:

Similar Artilces:

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

Daylight Savings Time Changes
Hello, Does anyone know if the patch for Exchnage 2003 identified in KB926666 has to also be applied to every server that is running the Exchange Tools (System Manager)? Thanks in advance K On Wed, 31 Jan 2007 10:24:03 -0800, Kerry <Kerry@discussions.microsoft.com> wrote: >Hello, > >Does anyone know if the patch for Exchnage 2003 identified in KB926666 has >to also be applied to every server that is running the Exchange Tools (System >Manager)? > >Thanks in advance >K Im all for consistency. If the patch isnt needed, it shouldnt install, so I would at ...

Calculated Field in form to table
Can you take a calculated field from a form and pull it in to a table?? ...

how do Ii remove the grey page numbers in a work sheet
how do Ii remove the grey page numbers in a work sheet Try going to the View menu and unchecking Page Break Preview On Wed, 2 Feb 2005 11:01:08 -0800, "parker1230" <parker1230@discussions.microsoft.com> wrote: >how do Ii remove the grey page numbers in a work sheet You may be in page break preview mode. Go to "View" and select "normal" Regards Bill K "parker1230" <parker1230@discussions.microsoft.com> wrote in message news:5A65FC73-CAA0-428D-8ECD-0C2A2E15B799@microsoft.com... > how do Ii remove the grey page numbers in a work she...

No calculation on new machine
I run XP Home with Office 2002 I have just installed my programs to a new machine. Excel is behaving differently on the new machine: Observed so far: i) I cannot select a cell by moving with the arrow keys. ii) I can insert a calculation, SUM for instance, into a cell and I get a 0.00 result. iii) Format > Cells provides three options, Border, pattern and protection. The old machine additionally gave me number, alignment and font. What have I miised? Thanks, Robin Chapple Hi Robin, Check your status bar that you do not have SCRL on the right side to indicate Scroll Lock (there i...

Windows mail times out sending wmv file in windows mail
Cannot send a wmv file 5.10MB, recieves just fine but times out when sending. The size is probably the issue. An attachment adds to the size about 35% due to encoding, so your 5.10MB file is now roughly 7MB. You can try the following, but it will only help if your server allows a message of that size. In Tools | Accounts | Mail | Properties | Advanced, set the time-out slider to the max. Turn off e-mail scanning in your anti-virus program. It is a redundant layer of protection that eats up CPUs, slows down sending and receiving, and causes a multitude of problems such as ...

logging date & time of data entry for individual cell
I'd like to log the time & date that content was entered into a (formerly empty) cell. When any data is manually entered into cell A1, the then-current time & date goes into cell B1 (and henceforth doesn't change). When data is entered into A2, the then-current time & date goes into cell B2. Once data has been entered into a cell, it will not be edited again. Can anyone suggest the best way of doing this? Thanks! Julz Put the following macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Set r = Range("A:A") If Intersec...

Division for TOTAL
Historical price for TOTAL (FR:FP) remains stopped at split date (may 18th 2006 - 4 for 1) and has not bit divided. Yield calculation on Money are consequently wrong. The American ADRs for TOT are ok; are prices for other securities downloading successfully? -- Michael Gordon MVP "Michel Gervais" <Michel_Gervais@Compuserve.com> wrote in message news:%23OKlf7HtGHA.1888@TK2MSFTNGP03.phx.gbl... > Historical price for TOTAL (FR:FP) remains stopped at split date (may 18th > 2006 - 4 for 1) and has not bit divided. Yield calculation on Money are > consequently ...

table and form not calculated in synch
Help says to open a piviot table but I am having trouble making my columns add up to total for each indivudual ID. The totals are being calculated only in th e form view which does not up date the original table and does not transfer to a report. How can I get a feild to calculate specific feilds so that I can run these reports? ...

Subtract several rows from a total
This is a multi-part message in MIME format. ------=_NextPart_000_0029_01C53AC8.AD6EB0F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 = and have the answer in cell C41. I know that =3DC32-C34 will give me an = answer but I want several rows to be subtracted. What would my formula = be? I have used the insert function feature before but I don't see diff or = anything that looks like a subtraction function in there. =20 Thanks, Linda ------=_NextPa...

Adding Values From Different Tabs
Is there a way to add values from different tabs on the same spreadsheet? For example A2 from tab 1 and A2 from tab 2 -- Flipkid2 ------------------------------------------------------------------------ Flipkid2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17984 View this thread: http://www.excelforum.com/showthread.php?threadid=398184 Assuming the name on Tab 1 is Sheet1 and Tab 2 is Sheet2, use thi formula: =Sheet1!A2+Sheet2!A2 note the name of the sheet is followed by "!" to indicate it is a shee name. HTH Bruc -- swatsp0 ------------...

Total is sum of bold values
Suppose I have a the following columns in a Excel Worksheet :- A B C D 4 (b) 6 4 (b) 5 6 6 (b) 6 (b) 6 3 (b) 6 (b) 4 4 6 4 (b) 3 1 (b) -------------------------------------------------- SUM -------------------------------------------------- 7 16 10 1 The totals add only the values that are bold.. (b denotes bold text) How can I make this (Total/Bold) functionality to work in Excel ? See http://www.mvps.org/dmcritchie/excel/formula.htm#BoldSum -- Regards, Peo Sjoblom "Saj" <shissa@leics.gov.uk> wrote in message news:09ea01...

Use Outlook Client when domain user name different with email acco
Hello, I have a question about using Outlook Client. If the domain user login name is different with email account which belong to a same person, is it possible to install / login with the Outlook client? e.g domain user : degdom\apple email account: applewatson@deg.com One of my client is facing in this situation. I just want to have some preparation before install Outlook Client for him. Thanks for any help! Hi Huimc, It shouldn't be a problem if the AD user is the same used to start Outlook and connect to CRM. You may want to check the email adress in CRM if the ema...

Business Portal - Executive
Hi, Does any one have any idea to fix Total Expenses Query - web part under Executive tab of the business portal to display selected company result instead of only Fabricam's data always irrespective of the company selection. Thanks You can select the company. Go to Site actions - Edit the page, then Edit the query, then on the Modify Query window go to the Options tab and select the company there. "Naseer Farooqi" wrote: > Hi, > > Does any one have any idea to fix Total Expenses Query - web part under > Executive tab of the business ...

Help with Calculation #2
Hi, I have the following XLS with 3 sheets: Credits, Inventory & Debits. Credits sheet (Stock sold) columns: 'Product Code', 'Product' (Text field) & 'Quantity' Inventory fields: 'Product' (Text field), 'Company', 'Supplier', 'Product Code', 'Quantity', 'Cost Price' & 'Retail Price'. Debits Sheet (Stock bought) columns: 'Product Code', 'Product' (Text field), 'Quantity' & 'Total cost'. New stock entered as 'Product Code', 'Product', 'Quantity&#...

Calculate from another sheet
If i in a sheet have a1=1 , b1 =2 , c1 = 3 , d1 = 4, e1 = 5 and so on and in a2 = 100, B2 = 100, c2 = 100 , e2 =100 ans o on Then in another sheet i write maybe 4 then i want a cell there have a sum from 1 to 4 In this case from a2 to e2 if I write maybe 2 The a sum from a2 to b2 Can i do this? If 4 is A2 to E2, and 2 is A2 to B2, presumably 3 is A2 to about half way between C2 and D2? It sounds as if you want the OFFSET function; details in Excel help. -- David Biddulph "alvin Kuiper" <alvinKuiper@discussions.microsoft.com> wrote in message new...

How do I create a spread sheet for tracking batting statistics?
Trying to keep a running log of batting stats for the season. Can anyone help? http://www.baseball-almanac.com/bstatmen.shtml "Robert" wrote: > Trying to keep a running log of batting stats for the season. Can anyone help? ...

Calculate Dates with If Then Else Statements
I need to calculate total years’ full time experience (i.e. 2.5 years, 3.25 years, etc.) in an Access 2003 database form. This is what I am trying to do: If the Full-Time End Date is Blank, use Today's Date, ELSE if the Full-Time End Date has a Date, use that Date. Separately, these two formulas work: =DateDiff("m",[FullTimeStartDate],Now())/12 =DateDiff("m",[FullTimeStartDate],[FullTimeEndDate])/12 My problem is writing a statement to calculate using the END DATE if one is entered, or NOW, if there is no end date. I have tried many combinations, but can’t ge...

Running macros for different cells at the same time
Hi all, Is it possible to run different macros on different cells at the sam time? If so how do I go about setting it up? Cheers Michae -- Message posted from http://www.ExcelForum.com Hi not really sure what you're trying to do. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany > Hi all, > > Is it possible to run different macros on different cells at the same > time? If so how do I go about setting it up? > > Cheers > > Michael > > > --- > Message posted from http://www.ExcelForum.com/ Yes it is possible to run different m...

Outlook locks up all the time
This is a shot in the dark. Ever since getting my new Thinkpad with Windows XP, Outlook has never seemed to work properly. I've run diagnostics on my machine and nothing comes up as a problem. I've installed a spyware program because after talking to IBM tech support, they suggested I try that. I also talked to another support tech, who suggested I reinstall Windows completely. I'm not a real technical person. Won't a re-install wipe out my files? Most of the time that I use Outlook for my email, it slows down and eventually locks up. When I restart my computer,...

Running Totals
I have several fields that I want to sum and display a text box with a running total. I do not want to store the total I just want to display the running total. Thank you for any assistance you can offer. Frank If you mean fields in the form's record source, then create a hidden text box for each field (if it is not already bound to a control on the form). Then in the text box where you want to show the sum use the Control Source property: =Nz(textbox1,0) + Nz(textbox2,0) + NzUtextbox3,0) -- Dave Hargis, Microsoft Access MVP "Frank" wrote: > I have several fields...

MC++ & C# generate different XML
Hi, I've been trying a long time now to generate some XML using MC++ and XmlSerializer. I have a piece of C# code that produces exactly what I want, but I simply can't get the MC++ code to write the same thing. Below I have included two minimal compilable samples that illustrate my problem. The C# code produces this XML: <?xml version="1.0" encoding="utf-8"?> <LandXML xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Units name="unit1" /> <Units name="un...

conditional formatting: separating rows with differing values
Hi, Need help with conditional fomatting. What I need: I got a worksheet with 950 rows and 5 columns. The first row contain the headers. Columns A, B, D and E contains unique values. But the column C contains text values which repeats sequentially for 6-7 rows and changes thereafter. Now I want to put up a line (using border) through the whole row dividing this transition row. My Idea: Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so on till 2 consequtive values differ. Now divide the 2 rows using the border formatting option in conditional formatting dialog box. So...

"A Formula or sheet..."
Windows Vista Ultimate - SP1 RC1 Office 2007 Professional When I try to copy a worksheet I get the following: "A formula or sheet you want to move or copy contains the name '_XXXX', which already exists on the destination worksheet. Do you want to use this version of the name?" This messages appears many time before the sheet is finally copied. I have been clicking the yes button and the task is completed. Is there a work-around, or add in, that allows me to go in and delete all these names so I can just copy the sheet w/o all the extra effort. It seems to me I ran i...

Crosstab Query For Fiscal Year Totals
I want to write a crosstab query for FY totals that will show each month regardless of wether there is data or not. Any help on this is greatly appreciated. Thanks! The trick is column headings. Open the query in Design View. Right click up where the tables go and select Properties. In there is column headings. Put in the expected column names in order. Something like: "Jan","Feb","Mar" and so on. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "DevlinM" wrote: > I...