A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

need help w/formula for calculating overtime hours



 
 
Thread Tools Display Modes
  #1  
Old January 17th, 2005, 08:03 PM
jv749297
external usenet poster
 
Posts: n/a
Default need help w/formula for calculating overtime hours

i am trying to create a timesheet that calculates cells automatically when
data is entered. I am entering time "in" and "out" two times (first half of
day total, then second half of day total, after meal break) and then i have a
formula which calculates those totals. In algebraic terms, say: a+b=c, then
for the second half of the day: d+e=f. then c+f=h, to give total hours
worked. what i need to have is a formula that calculates a new cell (say,
"i") so that IF h is greater than or equal to a value of 8.0 (hours per day),
then it automatically calculates the amount of hours over 8.0, keeping the
regular hours worked 8.0 in cell "h", and calculating the overtime hours as
anything over 8.0 into new cell, "i". hope that makes sense? can anyone
help me? thank you!!!
  #2  
Old January 17th, 2005, 08:54 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

In h1: =MIN(C1+F1,--"08:00:00")

In i1: =C1+F1-H1

format the cells as time

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jv749297" wrote in message
news
i am trying to create a timesheet that calculates cells automatically when
data is entered. I am entering time "in" and "out" two times (first half

of
day total, then second half of day total, after meal break) and then i

have a
formula which calculates those totals. In algebraic terms, say: a+b=c,

then
for the second half of the day: d+e=f. then c+f=h, to give total hours
worked. what i need to have is a formula that calculates a new cell (say,
"i") so that IF h is greater than or equal to a value of 8.0 (hours per

day),
then it automatically calculates the amount of hours over 8.0, keeping the
regular hours worked 8.0 in cell "h", and calculating the overtime hours

as
anything over 8.0 into new cell, "i". hope that makes sense? can anyone
help me? thank you!!!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtracting paid hours from unpaid hours ejerry7 Worksheet Functions 5 November 29th, 2004 05:16 AM
too complex for me! RandyH Setting Up & Running Reports 8 July 2nd, 2004 05:37 PM
SumIf Formula help to figure CA Overtime Laws maxwellkitty Worksheet Functions 1 March 12th, 2004 03:59 PM
NEED HELP WITH FORMULA FOR CALC HOURS AND OVERTIME PhAnToMiCe71898 Worksheet Functions 1 September 26th, 2003 04:47 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.