Re: how do I write a formula that will figure weekly overtime?

I replied before, but with the troubles this afternoon, it appears it didnt
get through......here 'tiz again........

This TimeKeeping thing is not really my forte, but here's my shot.........
First off, I would not just use times, but instead use Date-times, such as
"4/10/05 4:00:00AM"........This would seem to solve the problems associated
with going past the 24 hour mark.........then assuming your start time was
in A1 and your finish time in B1, a Conditional Format formula would be,
=DAY($B$1)>DAY($A$1)

hth
Vaya con Dios,
Chuck, CABGx3

"jasperPcuccumber" <jasperPcuccumber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:F10B1F91-8E49-4094-B5A7-22F023A89D2B@xxxxxxxxxxxxxxxx
> Ok another one Chuck.
> We have some employees who work swing and grave. They punch in before
> midnight and sometimes out for lunch before midnight sometimes after.
They
> may or may not finish the shift after midnight. I need a conditional
format
> formula that will differentiate between the two.
> Can you help????
>
> "CLR" wrote:
>
> > Total hours in A1
> > In B1 put =MIN(A1,40)..........this is Straight time hours
> > In C1 put =IF(A1>40,A1-40,0)...........this is OT hours
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "jasperPcuccumber" <jasperPcuccumber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> > message news:0B21F9A7-334E-40D3-8C6F-C642D5A61A02@xxxxxxxxxxxxxxxx
> > > I need to break down the hours only into straight time and ot. If A1
is
> > 32
> > > hours total time then C1 should show "0" over time hours. If A1 is 42
> > hours
> > > total then C1 should show"2" overtime hours. I can't figure out how
to
> > > create this formula.
> > >
> > > "CLR" wrote:
> > >
> > > > Total hours in A1
> > > > Rate per Hour in B1
> > > > In C1 put this formula......copy down if desired..........
> > > >
> > > > =IF(A1<=40,A1*B1,(40*B1)+((A1-40)*B1*1.5))
> > > >
> > > > Vaya con Dios,
> > > > Chuck, CABGx3
> > > >
> > > >
> > > >
> > > > "jasperPcuccumber" <jasperPcuccumber@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in
> > > > message news:01E9A355-B642-4CB4-803C-D543BE8EA624@xxxxxxxxxxxxxxxx
> > > > > I am setting up a payroll work***. I need a cell to show total
> > hours,
> > > > one
> > > > > for regular time and one for over time. What formatting or
formula
> > can I
> > > > use
> > > > > to figure over time and straight time based on 40 overtime rule?
> > (anything
> > > > > over 40 hours in a week is overtime)
> > > >
> > > >
> > > >
> >
> >
> >


.