Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jv749297
 
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   Report Post  
Bob Phillips
 
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
...
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!!!



Reply
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
Adding hours and minutes Patrick Excel Worksheet Functions 16 June 18th 08 09:24 PM
calculate difference in time to hours Chris Excel Worksheet Functions 5 January 18th 05 07:07 PM
Subtracting paid hours from unpaid hours ejerry7 Excel Worksheet Functions 5 November 29th 04 05:16 AM
Help! I am stuck calculating Days, Hours, Mins please help OB1 Excel Worksheet Functions 3 November 15th 04 06:17 PM
IF or SUMIF help for Overtime Formula Myrna Excel Worksheet Functions 2 November 8th 04 05:01 PM


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

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

About Us

"It's about Microsoft Excel"