|
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
31
|
|
|
153 registered members (M48scout, fishunt1001, mathews prostaff, Turkey Petter, Paint Rock 00, TurkeyJoe, Scdoghunter667, Narrow Gap, weatherby, sawdust, Camden86, jb20, Turkeyneck78, AUdeerhunter, Bustinbeards, Chiller, FastXD, Ryano, cartervj, Johnal3, hallb, Floorman1, geeb1, BigEd, BigA47, AU7MM08, bug54, Jerstwrt, Strictlybow, techtony, Cactus_buck, IMISSALDEER, FreeStateHunter, Big Al, Fattyfireplug, CNC, CKyleC, trailertrash, cchoque93, dirtwrk, Ridge Life, Mbrock, jaredhunts, Drycreek, GRINNING, BamaPlowboy, Roondog, leroycnbucks, TSB, Andalusia, jwalker77, deadeye48, Chancetribe, Claims Rep., Dubie, Semo, Ray_Coon, cbs, RidgeRanger, KnightRyder, walt4dun, klay, Whild_Bill, Madmax0818, 300gr, RobN25, MikeP, btfl, Big Buck Video, Okatuppa, mikewhandley, bambam32, mashburn, BCLC, just_an_illusion, metalmuncher, capehorn24, booner, RSF, !shiloh!, chevydude2015, Whitetaillane, demp17, Big AL 76, russellb, phinfan, 7PTSPREAD, Reaper, mw2015, Dixiepatriot, Offshore, jawbone, jchurch, woodduck, Jotjackson, BhamFred, Doeslayer44, JSOG47, GHTiger10, outdoorguy88, Scout308, fourfive45, Recovered, ts1979flh, Bronco 74, Hunter454, Jason Carroll, TheVern, BobK, oakachoy, Nowlide, Dean, roll_tide_hunts, Hoytdad10, AU338MAG, beRAD, riflenut, sj22, 7mmSTW, Jbf, GomerPyle, 3bailey3, Moose24, thayerp81, SEWoodsWhitetail, ronfromramer, Mack1, hamma, johndeere5036, BearBranch, hoggin, TreeBender, Chaser357, blade, BAR1225, JAT50, zwick, Fedex 1, foldemup, JHL, Rockhound, Morris, crenshawco, Buck1976, eclipse829, auburn17, 7 invisible),
1,261
guests, and 0
spiders. |
Key:
Admin,
Global Mod,
Mod
|
|
|
Re: Question for the Excel gurus
[Re: KYLongGun]
#1258056
02/09/15 08:00 AM
02/09/15 08:00 AM
|
Joined: Oct 2009
Posts: 552 Ohio
yoteslayer0927
OP
4 point
|
OP
4 point
Joined: Oct 2009
Posts: 552
Ohio
|
Try this. Add a column next to the current times. In the new cell right next to the time type "='cell reference of original time'+ .021". This should give you the time plus 30 min. I'm not sure why it is .021 but it is. I'm not sure I understand your second question. Give me a littel more information and I may be able to help. Feel free to PM me your email address and I can send you a formula with the first part if you like. That works....so my second problem......I have a group of surveys that are 1 hour in length. During these surveys I have several observations that occurred throughout the hour long survey period. The time of each observation was recorded. What I need is to designate any of the observations made in the first 30 minutes as "A" observations and any observations made in the last 30 minutes as "B" observations. Thanks Brian
|
|
|
|