Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLookup and how it works
I am currently designing a timesheet template so that it will automatically
dissect total hours worked into Ordindary Hours (max 7.6hr per day, Time&Half next 3 hrs, and the balance will be Double time). I'm not sure which would be the best function to assist. I have used the=IF function but there are flaws. Can anyone suggest which function woulb be more appropraite? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLookup and how it works
Hi!
A2 = hours worked for the day B2 = Ordindary Hours: =MIN(ISNUMBER(A2)*A2,7.6) C2 = Time&Half: =MIN(3,A2-B2) D2 = Double time: =A2-B2-C2 Biff "Marjolyn Noble" <Marjolyn wrote in message ... I am currently designing a timesheet template so that it will automatically dissect total hours worked into Ordindary Hours (max 7.6hr per day, Time&Half next 3 hrs, and the balance will be Double time). I'm not sure which would be the best function to assist. I have used the=IF function but there are flaws. Can anyone suggest which function woulb be more appropraite? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|