Sounds good but where do I put the overtime rate?

"Bob Phillips" wrote:

Depends upon the rules.

For instance, if anything over 8 hours is overtime then

=MAX(end_time-start_time-TIME(8,0,0),0)

If it is any hours outside ofv pre-set start and end times, say 08:00 and
16:00 then

=MAX(TIME(8,0,0)-start_time,0)+MAX(end_time-TIME(16,0,0),0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AHurd" wrote in message
...
Timesheet Formula: I am trying to create a formula to calculate whether
the
hours used are either time and a half between x-y hours. Completely
useless
on Excel.