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.