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!