JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,691
- Office Version
- 365
- Platform
- Windows
I am working on a little project to help the grandkids, as they near college age, decide what they want to do with their lives. One bit of information that I never had, was the expected income for various professions. I created the sheet below. I would like to convert it to a table so I can get the benefits, but it's really two tables. I can't see a way to set up two tables so that one can refer to the other. Any suggestions?
Note: The time values are calculated by my FmtTime UDF. I wrote it specifically for situations like this where the time varies widely. It returns the time in the smallest units that are >= 1.
Cell Formulas | ||
---|---|---|
Range | Formula | |
E4 | E4 | =(25+43)/2*1000 |
F4 | F4 | =(23+50)/2*1000 |
G4 | G4 | =(21+72)/2*1000 |
I4 | I4 | =(61+110)/2*1000 |
J4 | J4 | =(70+170)/2*1000 |
K4 | K4 | =(100+150)/2*1000 |
L4 | L4 | =(120+200)/2*1000 |
M4 | M4 | =(68+390)/2*1000 |
E5:M5 | E5 | =E4/365.25/8 |
E6:M15 | E6 | =fmttime(@Price/@RateCol,0,"hrs") & " " |
C10 | C10 | =120*12 |
Note: The time values are calculated by my FmtTime UDF. I wrote it specifically for situations like this where the time varies widely. It returns the time in the smallest units that are >= 1.