Sorry, Ican't get this to work. Anybody wanna email me a spreadsheet
withthis already done somehow? I apologize.

Nick Hodge wrote:
Adding to my answer, as you have a different interpretation from Elkar...I
am presuming you are entering times as times recognisable to Excel, 40:00:00
as opposed to whole numbers (40), which Excel will see as days

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Nick Hodge" wrote in message
...
Sum the total hours (You will need to format this as [hh]:mm or hours over
24 will show as days

Then, presuming this sum is in G1, enter in H1

=IF(G1<1.708333,G1,1.666666)

in I1 enter

=IF(G1=1.708333,G1-1.708333,0)

format the results as [hh]:mm (via FormatCells...Custom)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


wrote in message
oups.com...
Anyone out there can help me with a worksheet project? I am trying to
set up a timesheet formula where I can input the total number of hours
worked in the wek and then have it calculate into two seperate cells,
regular hours (hours under 41) and overtime (hours over 40). I know
this seems simple,but how do I do it if the hours are less than 40?
Does this make sense? This is stumping me right now.