Time Help
 

I have a brain fart I've been working on this for two days now and I know I'm
making it to hard. What I need is a formula I doing a time sheet, if I work
160 hours in a month I get 6 hours and 40 minutes of vaction time. So what
in need is a formula that caculates if I work lets say 150 hours I get ?
hours and ? minutes of vaction.

One way:

If your total, in time format, is in A1:

=A1/TIME(160,0,0)*TIME(6,40,0)

or, more efficiently:

=A1 * 0.4166666666667

In article ,
"Kelly Thompson" wrote:

I have a brain fart I've been working on this for two days now and I know I'm
making it to hard. What I need is a formula I doing a time sheet, if I work
160 hours in a month I get 6 hours and 40 minutes of vaction time. So what
in need is a formula that caculates if I work lets say 150 hours I get ?
hours and ? minutes of vaction.

A1: 150
A2: 160
A3: 6:40:00

=A1*A3/A2

and format as time.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a brain fart I've been working on this for two
days now and I know I'm
making it to hard. What I need is a formula I doing a
time sheet, if I work
160 hours in a month I get 6 hours and 40 minutes of
vaction time. So what
in need is a formula that caculates if I work lets say
150 hours I get ?
hours and ? minutes of vaction.
.

Thank you two both of you.

"Kelly Thompson" wrote:

I have a brain fart I've been working on this for two days now and I know I'm
making it to hard. What I need is a formula I doing a time sheet, if I work
160 hours in a month I get 6 hours and 40 minutes of vaction time. So what
in need is a formula that caculates if I work lets say 150 hours I get ?
hours and ? minutes of vaction.