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!

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!

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!