Timesheet maximum hours problem

I have created a time sheet for biweekly payroll, but I have one
problem.

Cell: I12 is the total for one week

Cell: D24 is the above total copied

Cell:D26 is regular hours worked - and this is where I have the
problem.

I want this cell to copy the value from D24 or input 44:00 hours,
which ever is less, in time format.

Can you help

Thank you

=Min(D24,time(44,0,0))

and format as time

--

HTH

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


"Good Time" <[email protected]> wrote in message
news:[email protected]...
> I have created a time sheet for biweekly payroll, but I have one
> problem.
>
> Cell: I12 is the total for one week
>
> Cell: D24 is the above total copied
>
> Cell:D26 is regular hours worked - and this is where I have the
> problem.
>
> I want this cell to copy the value from D24 or input 44:00 hours,
> which ever is less, in time format.
>
> Can you help
>
> Thank you

Hi!

Try this:

=MIN(D24,44/24)

Format the cell as [h]:mm.

Biff

"Good Time" <[email protected]> wrote in message
news:[email protected]...
>I have created a time sheet for biweekly payroll, but I have one
> problem.
>
> Cell: I12 is the total for one week
>
> Cell: D24 is the above total copied
>
> Cell:D26 is regular hours worked - and this is where I have the
> problem.
>
> I want this cell to copy the value from D24 or input 44:00 hours,
> which ever is less, in time format.
>
> Can you help
>
> Thank you

Thanks for your help but this formula always returns the value 44:00.

The problem is if cell D24 is less than 44:00 hours, let say 22:00
than cell D26 should reflect 22:00.

If cell D24 is greater than 44:00 than cell D26 should reflect the
maximum of 44:00 which your formula does.

Can you help?
>Hi!
>
>Try this:
>
>=MIN(D24,44/24)
>
>Format the cell as [h]:mm.
>
>Biff
>
>"Good Time" <[email protected]> wrote in message
>news:[email protected]...
>>I have created a time sheet for biweekly payroll, but I have one
>> problem.
>>
>> Cell: I12 is the total for one week
>>
>> Cell: D24 is the above total copied
>>
>> Cell:D26 is regular hours worked - and this is where I have the
>> problem.
>>
>> I want this cell to copy the value from D24 or input 44:00 hours,
>> which ever is less, in time format.
>>
>> Can you help
>>
>> Thank you
>

Thanks for your response but this formla seems to return
a fixed value of 22:00. Am I doing something wrong?

>=Min(D24,time(44,0,0))
>
>and format as time

No it's not always returning 44, so the only other option is that the 22:00
is either text or not 22:00


--

Regards,

Peo Sjoblom

"Good Time" <[email protected]> wrote in message
news:[email protected]...
> Thanks for your help but this formula always returns the value 44:00.
>
> The problem is if cell D24 is less than 44:00 hours, let say 22:00
> than cell D26 should reflect 22:00.
>
> If cell D24 is greater than 44:00 than cell D26 should reflect the
> maximum of 44:00 which your formula does.
>
> Can you help?
> >Hi!
> >
> >Try this:
> >
> >=MIN(D24,44/24)
> >
> >Format the cell as [h]:mm.
> >
> >Biff
> >
> >"Good Time" <[email protected]> wrote in message
> >news:[email protected]...
> >>I have created a time sheet for biweekly payroll, but I have one
> >> problem.
> >>
> >> Cell: I12 is the total for one week
> >>
> >> Cell: D24 is the above total copied
> >>
> >> Cell:D26 is regular hours worked - and this is where I have the
> >> problem.
> >>
> >> I want this cell to copy the value from D24 or input 44:00 hours,
> >> which ever is less, in time format.
> >>
> >> Can you help
> >>
> >> Thank you
> >

See Peo's response.

--

HTH

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


"Good Time" <[email protected]> wrote in message
news:[email protected]...
> Thanks for your response but this formla seems to return
> a fixed value of 22:00. Am I doing something wrong?
>
> >=Min(D24,time(44,0,0))
> >
> >and format as time

That was the problem, one of my cells had text in it.

Thanks so much for your help.

>No it's not always returning 44, so the only other option is that the 22:00
>is either text or not 22:00