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

All the employees may or may not punch at any time. Sometimes any punch
coulc be before midnight and any punch could be after midnight. I need
conditional format that discerns 24 hour clock, so a punch as follows would
work;

A1 21:05 in B1 23:45 out C1 00:15 in D1 4:00 out
or
A1 23:00 in B1 00:45 out C1 1:15 in D1 5:05 out
or any other combination that spans over the midnight hour.

"Myrna Larson" wrote:

> Between which 2? The quitting time (before or after midnight) or when they
> take their lunch break?
>
> If it's the former, and you have start time in A1, lunch start in B1, lunch
> end in C1, quitting time in D1, and those times do NOT include the date, the
> formula
>
> =(D1<A1)
>
> will be true for those who quit after midnight, false for those who quit
> before midnight.
>
>
> On Sat, 9 Apr 2005 21:23:02 -0700, "jasperPcuccumber"
> <jasperPcuccumber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >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)
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>
.