Thread
:
Employee Time Sheets?
View Single Post
#
4
Posted to microsoft.public.excel.misc
Nick Hodge
Posts: n/a
Employee Time Sheets?
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.
Reply With Quote