# Search:

Type: Posts; User: thisoldman; Keyword(s):

Page 1 of 6 1

1. ## Thread: Clipboard History issue in VB Editor

by thisoldman
Replies
3
Views
161

### Re: Clipboard History issue in VB Editor

There are a bunch of free Clipboard managers for Windows available—too many to choose one to recommend.

Have you tried the built-in Office Clipboard manager? It shows the clipboard history and...
2. ## Thread: axis automatic range and grid line increments

by thisoldman
Replies
1
Views
164

### Re: axis automatic range and grid line increments

Try "How Excel Calculates Automatic Chart Axis Limits" by Jon Peltier, https://peltiertech.com/how-excel-calculates-automatic-chart-axis-limits/.
3. ## Thread: Simple Fx question

by thisoldman
Replies
4
Views
179

### Re: Simple Fx question

joeu2004, I also considered a solution like yours but brose99 wrote that the formula was in A6.
4. ## Thread: Simple Fx question

by thisoldman
Replies
4
Views
179

### Re: Simple Fx question

Try this.

=AVERAGE(INDEX(A:A,1):INDEX(A:A, 4))
5. ## Thread: Shift Pay Calculations

by thisoldman
Replies
2
Views
198

### Re: Shift Pay Calculations

Try this in E4 and copy downward.

=IF(OR(HOUR(C4)>=18, HOUR(C4)< 4), \$H\$5*\$J\$4,
IF(AND(HOUR(C4)>=4, HOUR(C4)+\$J\$4<=18), \$H\$4*\$J\$4,
\$H\$4*(18-HOUR(C4)) + \$H\$5*(\$J\$4+HOUR(C4)-18)))
6. ## Thread: IF - Logical question

by thisoldman
Replies
5
Views
153

### Re: IF - Logical question

I'm glad to have helped. Thank you for posting back with your results.
7. ## Thread: IF - Logical question

by thisoldman
Replies
5
Views
153

### Re: IF - Logical question

Using true dates in C1:AA1 made the formula much easier for me to write.

In C1, enter 1-Sep-2017.
Right-click-grab the small square drag handle at the lower-right of C1 and drag through to AA1....
8. ## Thread: Not sure if nested IF, with AND, in addition to OR, unless there's a better way?

by thisoldman
Replies
15
Views
1,070

### Re: Not sure if nested IF, with AND, in addition to OR, unless there's a better way?

You can have up to 64 nested IF() functions; this changed with Excel 2007.

Your word description doesn't fully describe the outcome for each pairing. Will you please give the proper answer for the...
9. ## Thread: Excel 2010 vs 2013 TableStyle naming

by thisoldman
Replies
3
Views
120

### Re: Excel 2010 vs 2013 TableStyle naming

The colors change with the "Page Layout" and theme colors—changing the color scheme from the menu's "Page Layout" tab changes the colors offered on the "Design" tab for the table. I have not explored...
10. ## Thread: Date Calculation Assistance

by thisoldman
Replies
3
Views
210

### Re: Date Calculation Assistance

I'm glad to help. Thanks for getting back to us.
11. ## Thread: Highlight all jobs belonging to one client

by thisoldman
Replies
4
Views
269

### Re: Highlight all jobs belonging to one client

Rules apply to \$A\$2:\$H\$7

Order of the rules, top to bottom, as they appear in the 'Conditional Formatting Manager':

Green row if the Organization has TRUE in any record::...
12. ## Thread: Highlight all jobs belonging to one client

by thisoldman
Replies
4
Views
269

Try this.

<tbody>

A
B

1
13. ## Thread: Highlight all jobs belonging to one client

by thisoldman
Replies
4
Views
269

### Re: Highlight all jobs belonging to one client

Oops! What I posted doesn't work.
14. ## Thread: conditional formatting inserting bar based on cell value

by thisoldman
Replies
1
Views
140

### Re: conditional formatting inserting bar based on cell value

Instead of Conditional formatting data bars, would a column sparkline do what you want? You can set the axis parameters of the miniature column chart from the Design tab.
15. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

I used conditional formatting to highlight weekends and holidays. Custom number formatting was used to hide zeros in the shift table.

16. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

Formulas are used to place the shift hours in their proper columns.

The formulas for the columns not shown are similar.

17. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

For the hours to appear in the report in their proper columns, I added a cell, controlled with a data validation dropdown, for the user to enter the month. Another cell is reserved for the user to...
18. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

The first step is to calculate the start and end times for each date.

If a start time exists in that row but no end time, the end time is taken as midnight. If an end time exists but no start...
19. ## Thread: Date Calculation Assistance

by thisoldman
Replies
3
Views
210

### Re: Date Calculation Assistance

Try this.
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
20. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

From an email sent to me:
21. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

The current timesheet is a table in a a Word file, docx format. This is an image of it.

https://i.imgur.com/79zq8ax.png

Here are the first few rows of the table, after copying it to Excel:
...
22. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

If you can reduce the spreadsheet to say six rows by perhaps ten columns, you can copy and directly paste into a forum post.

You can use an Excel add-in, see...
23. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

Before you send me anything, be aware that I will repost the anonymized information in the forum.
24. ## Thread: VBA: C.Williams' MicroTimer – Why include the line 'MicroTimer= 0'

by thisoldman
Replies
2
Views
416

### Re: VBA: C.Williams' MicroTimer – Why include the line 'MicroTimer= 0'

Thank you, Eric. That was my suspicion. I am all for eliminating lines of code, especially for a language that I find to be verbose. I would have voted for implied over explicit in this script.
25. ## Thread: Distribute total working hours to three shifts

by thisoldman
Replies
13
Views
411

### Re: Distribute total working hours to three shifts

OK.
Results 1 to 25 of 150
Page 1 of 6 1