Time Help

[Guest]

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.

 

[JE McGimpsey]

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

 

[Jason Morin]

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

=A1*A3/A2

and format as time.

HTH
Jason
Atlanta, GA

 

[Guest]

Thank you two both of you.