How to get exact hours above a spesific time?

[MrHaugen]

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

On saturdays I get 50% overtime paymant after 12:00 o'clock. Want t
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 an
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 hav
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]

Thanks alot.
The TIME function worked like a charm!