creating a time formula
 

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

creating a time formula
 

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

creating a time formula
 

5 and 1/4 hours
enter 5.25

5 and 3/4
enter 5.75

"J.W.R." wrote:

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

creating a time formula
 

Format your "hours worked" column as time, and enter 5 and 1/4 hours as
5:15, for example. If that is column A and your hourly rate is in B, then
your formula is =A1*B1*24, and format the result as General (or number, or
currency).

If, of course, you want to enter your hours worked as 5.25 (formatted not as
time but as number or general), then you can just multiply A1*B1.
Similarly if you enter hours worked as 5 1/4 (formatted as fraction), again
A1*B1 will give you the answer.
--
David Biddulph

"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