How to get exact hours above a spesific time?

[MrHaugen]

I have a problem getting the hours I work overtime to be calculated. I have a field with start time (A1) and end time (A2).

On saturdays I get 50% overtime paymant after 12:00 o'clock. Want to calculate the hours past 12:00.
I have tried with things like IF(A2>12:00;"A3=A2-12:00;0.
I just CAN'T get it to work with the hour format. ONLY with numbers and text.
Is this impossible with the xx:xx format?

What could be done?
(PS. I know there might be errors in my example above. Just don't have the excel here to test it at this time.)

[Bob Phillips]

In A3

=IF(A2>TIME(12,0,0);A2-.5;A2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MrHaugen" <[email protected]> wrote in
message news:[email protected]...
>
> I have a problem getting the hours I work overtime to be calculated. I
> have a field with start time (A1) and end time (A2).
>
> On saturdays I get 50% overtime paymant after 12:00 o'clock. Want to
> calculate the hours past 12:00.
> I have tried with things like IF(A2>12:00;"A3=A2-12:00;0.
> I just CAN'T get it to work with the hour format. ONLY with numbers and
> text.
> Is this impossible with the xx:xx format?
>
> What could be done?
> (PS. I know there might be errors in my example above. Just don't have
> the excel here to test it at this time.)
>
>
> --
> MrHaugen
> ------------------------------------------------------------------------
> MrHaugen's Profile:
http://www.excelforum.com/member.php...o&userid=36191
> View this thread: http://www.excelforum.com/showthread...hreadid=559904
>

[MrHaugen]

Thanks alot.
The TIME function worked like a charm!