Search results

Pretty much works except 44 hours 55 minutes comes out as 44 hours 52 minutes. And that total came from 9:05, 8:35, 9:05, 9:05, 905. 44 hrs 55 min so there should not be any rounding down of whole minutes. Never mind. I got it. Was using wrong column in the minutes calc. Thank you so much!

So if I understand, if the result is 24 hrs or more, the result will only show the remainder OVER 24 hours. That is what it appears to do. So how do I take a result that is 44 hours and 35 minutes and multiply only the hours by 60 and also add the minutes? Or any result as far as that goes?

Simple worksheet where: Cell E6 is time in as in 7:28 AM cell formatted as h:mm Cell F6 is time out as in 4:32 PM and the cell is also formatted as h:mm Cell G6 is total using formula =IF(F6<E6,F6+1,F6)-E6 That works fine giving 9:04 My Problem is when I try to add say five days of the...

As a matter of information, now that my tournament is coming up, I used this and ultimately found that it will duplicate players. I also found using the formula =INDEX(range of names,MRAND()) in the number of cells I want results in it works great without VBA but does not restrict the team...

Thanks. I really appreciate that.

=IF(ISNUMBER(F9),IF(SUM(F9-E9)>=0,ROUNDUP(SUM(F9-E9)/2,0)+E9,IF(SUM(E9-F9)>1,(E9-1),E9))) This formula is in cell G9. It works fine except if there is no entry in cell F9, it displays the word FALSE. I want it to remain blank until there is an entry into F9. I have tried incorporating the ""...

One more question. I have a file with 10 or 12 worksheets that I run off of one sheet with names on it, handicaps, etc. Is there a way I can copy this into that workbook as additional worksheets and still maintain the code ? That way I can use my main player list for it to run from.

That appears to work great. Wish I understood all that. Thank you so much.

Seems I have totally screwed up in explaining what I am trying to do. I have a yearly tournament that has anywhere from 36 upwards to 50 players. The regular 3 day tournament is a 2 man team where the same 2 players play together all 3 days. I am trying to add a 'side' tournament where each...

No attachment

Wondering if this is possible in Excel. I have 40 golfers. Want to randomly pair them (2 man teams) each day for 3 days but without repeat pairs. If possible can someone put me on the right track ? Thanks

Thanks so much again. I'm sure you see what I am doing.. It is 2 man teams playing on a point system. Once all 3 days are input, just thought it would be simple to let the spreadsheet list them in order of finish (high to low) rather than looking down the list and picking them out. I'm sure...

I got it. Now would you mind explaining that formula ? I understand the ifs, ands, isnumbers, but not how the actual calc does it. Thank you so much.

That works fine but it squashes the row height on all the 'team' rows.

Well, yes and no. Guess I stated it wrong. What I am looking for is how to sort the whole sheet on the totals in column O so that I have the first place team first and so on but maintaining the layout of the sheet. I really don't think that even sounds possible. Sorry for the confusion.

In the attached file, tab(sheet 2016) column O. Is there a way I can rank the teams by team total and keep the overall format of the sheet ?

I am trying to display all 3 days in a report rather than having 3 different reports.

I hate to ask this because I know it is a simple solution that I just can't stumble on, but would someone mind telling me how to combine 3 queries into one giving three result columns instead of one ? All 3 are the same except the 'day'. Lists players and the average score each day Friday...

I am converting some of my excels to Open Office CALC (spreadsheet) part. Sorry I failed to state that.

Yeah, I thought I had it and dumb me copied it over all my original formulas with DATEDIF then realized I had something wrong. The YEAR was the missing part. Thanks so much.