Results 1 to 10 of 25
Thread: Need Help With Excel Formula! $10 Bucks
-
07-20-11, 01:15 PM #1
Need Help With Excel Formula! $15 Bucks
I'll keep this short. 15 bucks to the person that can formulate this formula.
I need help making a bus schedule system. Problem is that too many bus drivers are getting OT, need to make an excel spread sheet which shows the actual amount of hours for each bus driver.
I need help with 1 formula.
Section 1: Summary of Hours
Okay so the formula I'm having trouble with is in section 1 for "on pace hours". This field need to show the hours the drivers our on pace to meet. Also "Route Hours" is the drivers hours they use for picking up kids at school. This number is constant and a given. The schedule in section 2 is for field trips and these trips hours always vary because they don't know exactly how long the trip is going to take. This is why for every day there is a "assigned" hours and "actual" hours columns.
Section 2: Schedule
I know what I need but I don't know how to write out the formula: Here is what I need for "on pace hours":
For cell B6 I need =C6 + (H6, if H6 is empty use G6) + (J6, if J6 is empty use I6) + (L6, if L6 is empty use K6) + (N6, if N6 is empty use M6) + (P6, if P6 is empty use O6) + (R6, if R6 is empty use Q6) + (T6, if T6 is empty use S6)
I know it looks complicated but its really not. Whats going to happen is that at the end of every day someone will go into the schedule and enter all the actual hours it took for the drivers trip.
To get an "on pace hours" I need to add actual hours + assigned hours. However once an actual hour is recorded I need to use that number instead of the assigned hour for that day.
Here is the download link if anyone wants to download the excel file:
MaFioSo - Bus Schedule.xlsx
Any help is greatly appreciated, $15 for the first one that generates formula. I can send $ via pay pal or I can buy a steam game of equal or less value and then "gift" it to you through steam.
-
- Join Date
- 02-13-07
- Location
- Fort Worth, TX
- Posts
- 42,785
- Post Thanks / Like
- Blog Entries
- 5
07-20-11, 01:24 PM #2Re: Need Help With Excel Formula! $10 Bucks
Add a column between H and I, and put a formula in that says if H6>0 then H6, else G6. So then I6=H6 if it has a value, and if not it equals G6. Then do the same for each day. Then on your main formula you just have to add the hidden column from each day.
I am downloading Steam to my laptop, so hit me up here or there if you need help.
-
- Join Date
- 02-13-07
- Location
- Fort Worth, TX
- Posts
- 42,785
- Post Thanks / Like
- Blog Entries
- 5
-
-
- Join Date
- 02-13-07
- Location
- Fort Worth, TX
- Posts
- 42,785
- Post Thanks / Like
- Blog Entries
- 5
07-20-11, 01:36 PM #5Re: Need Help With Excel Formula! $10 Bucks
Try this:
MaFioSo - Bus Schedule.xlsx
-
-
07-20-11, 01:41 PM #7
Re: Need Help With Excel Formula! $10 Bucks
=C3+(IF(ISBLANK(H3),G3,H3)+(IF(ISBLANK(J3),I3,J3)+ (IF(ISBLANK(L3),K3,L3)+(IF(ISBLANK(N3),M3,N3)+(IF( ISBLANK(P3),O3,P3)+(IF(ISBLANK(R3),Q3,R3)+IF(ISBLA NK(T3),S3,T3)))))))
Change cell references as needed.
Same as Magus - don't need the moneyLast edited by Alundil; 07-20-11 at 01:59 PM. Reason: strange - looks like the forum just inserts a blank (probably wrap related)
-
-
-
- Join Date
- 02-13-07
- Location
- Fort Worth, TX
- Posts
- 42,785
- Post Thanks / Like
- Blog Entries
- 5
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks