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!
|