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

Hi Chuck,
I tried this but only get ##########. Maybe more clarification. Try it
once, maybe I am just entering it wrong.

"CLR" wrote:

> 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)
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>
.