Do you mean you want to ignore the minutes, round to the nearest hour,
roundup, or apprtion them? Assuming that your total hours is a time field

Ignore them

=INT(total_hours*24)*pay_per_hour

Round


=ROUND(total_hours*24,0)*pay_per_hour

Roundup


=ROUNDUP(total_hours*24,0)*pay_per_hour

Apportion


=(total_hours*24)*pay_per_hour

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"J.W.R." wrote in message
...
I need to know how and if this can be done. I have 3 columns one is for
total hours worked then the other is the rate of pay per hour the last is
total pay. In the total pay I want it to take the total hours worked
times
the pay rate and give me the total. The problem is that some hours worked
come out to 5 and 1/4 hours or 3/4 or half what is the formula I can use
to
figure out the hours and minutes worked? if it is even hours there is no
problem only when dealing with the minutes. Can anyone point me in the
right
direction Please.

Thank you so much.
--
5 P''s of Life
Prior
Planning
Prevents
Poor
Performane