Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet calculations
Hi folks-I'm a newbie here, so forgive me if my question is not so bright....
I am creating a timesheet for an operation that has staff possibly working from one calendar date through to another on overtime. I have employed an absolute function with the dates and times to accurately determine the number of hours (this all works very well). Now, I am at a loss as how to get the result to display as "8" in the regular hours column and the remaining hours (anything over 8) to display in the next column. I have used the greater than and if functions before, but I'm puzzled how to do this in the absolute calculation. If I make any sense, thanks much for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet calculations
If hours are in A1 and are 12 hours
regular hours in B1 would be if(a1 <= 8,A1,8) in C1 Overrtime would be if(a1 <= 8, 0, A1 - 8) Absolute would not make any difference for B1 if(abs(Endtime - Starttime) < 8, A1,8) for C1 if(abs(Endtime - Starttime) <= 8, 0, A1 - 8) "Nansi K." wrote: Hi folks-I'm a newbie here, so forgive me if my question is not so bright.... I am creating a timesheet for an operation that has staff possibly working from one calendar date through to another on overtime. I have employed an absolute function with the dates and times to accurately determine the number of hours (this all works very well). Now, I am at a loss as how to get the result to display as "8" in the regular hours column and the remaining hours (anything over 8) to display in the next column. I have used the greater than and if functions before, but I'm puzzled how to do this in the absolute calculation. If I make any sense, thanks much for your help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet calculations
Thank Joel-I should have known!
Nansi "Joel" wrote: If hours are in A1 and are 12 hours regular hours in B1 would be if(a1 <= 8,A1,8) in C1 Overrtime would be if(a1 <= 8, 0, A1 - 8) Absolute would not make any difference for B1 if(abs(Endtime - Starttime) < 8, A1,8) for C1 if(abs(Endtime - Starttime) <= 8, 0, A1 - 8) "Nansi K." wrote: Hi folks-I'm a newbie here, so forgive me if my question is not so bright.... I am creating a timesheet for an operation that has staff possibly working from one calendar date through to another on overtime. I have employed an absolute function with the dates and times to accurately determine the number of hours (this all works very well). Now, I am at a loss as how to get the result to display as "8" in the regular hours column and the remaining hours (anything over 8) to display in the next column. I have used the greater than and if functions before, but I'm puzzled how to do this in the absolute calculation. If I make any sense, thanks much for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timesheet | Excel Worksheet Functions | |||
Timesheet Calculations | Excel Worksheet Functions | |||
Timesheet help | Excel Worksheet Functions | |||
Timesheet | Excel Worksheet Functions | |||
timesheet | Excel Worksheet Functions |