counting days

BrianMH

Well-known Member

Joined

Mar 26, 2008

Messages

1,490

• Feb 24, 2014

• #2

Do you have work achieved on weekends or is this just weekdays?

 

Upvote 0

R

rantnrave

New Member

Joined

Jan 31, 2014

Messages

36

• Feb 24, 2014

• #3

BrianMH said:

Do you have work achieved on weekends or is this just weekdays?

Click to expand...

yes we operate 24 7 except during bad weather or port calls

 

Upvote 0

BrianMH

Well-known Member

Joined

Mar 26, 2008

Messages

1,490

• Feb 24, 2014

• #4

Ok.

I'm not sure your layout but this should get you started.

Excel Workbook
	A	B	C	D
1	Start Date	17/02/2014		Days Not Worked
2	End Date	24/02/2014		18/02/2014
3	Total Kilometers to Goal	1000		20/02/2014
4	Kilometers Travelled	500
5	Average Kilometers per day	100
6	Kilometers Left	500
7	Expected Date of Completion	01/03/2014
Sheet1

 

Upvote 0

R

rantnrave

New Member

Joined

Jan 31, 2014

Messages

36

• Feb 24, 2014

• #5

Hi Brian yes I can see how that would work however I only enter a date against km so I dont put a date down when nothing is run, I could do it that way but was hoping for something a little neater
What I need is to count the days so it needs to be able to recognise that we haven't worked "x" days in between

 

Upvote 0

BrianMH

Well-known Member

Joined

Mar 26, 2008

Messages

1,490

• Feb 24, 2014

• #6

Check out the link in my signature about posting tables as HTML. This is exactly why it is better to do that when explaining what you want to achieve. I'm guessing the below is more what you are looking for but if not please give some example data and an example of what you want to return. If this doesn't do what you need I won't be able to look at it any further without specific details of what you need.

Excel Workbook
	A	B	C	D	E	F	G
1	Worked Days	Kilometres		Goal	Remaining	Average per Day	Estimated Date Goal Met
2	20/02/2014	25		1000	625	125	01/03/2014
3	22/02/2014	250
4	24/02/2014	100
Sheet1

 

Upvote 0

R

rantnrave

New Member

Joined

Jan 31, 2014

Messages

36

• Feb 24, 2014

• #7

Unable to download due to server security restrictions will have to wait till i get home next week thankyou for your help however

 

Upvote 0

BrianMH

Well-known Member

Joined

Mar 26, 2008

Messages

1,490

• Feb 25, 2014

• #8

OK if you can't use the tool that's fine. You could try http://tableizer.journalistopia.com. Otherwise if you explain in detail what you want and how it differs from my last solution I'll try to help. Try to be as detailed as possible, as you can imagine I do this on a voluntary basis and am quite busy so I don't want to develop solutions that are not needed.

 

Upvote 0

R

rantnrave

New Member

Joined

Jan 31, 2014

Messages

36

• Feb 26, 2014

• #9

BrianMH said:

OK if you can't use the tool that's fine. You could try http://tableizer.journalistopia.com. Otherwise if you explain in detail what you want and how it differs from my last solution I'll try to help. Try to be as detailed as possible, as you can imagine I do this on a voluntary basis and am quite busy so I don't want to develop solutions that are not needed.

Click to expand...

Ok Brian
My spread sheet has lines (km) that we shoot in areas of the NORTH SEA so I have a column with the lines the next is the date when its completed and the next I have a column where I put c for complete p for part and r if it need to be re-run all the number stuff I have working but I'm trying to provide a completion date for the work If I take date last line minus date of first line I will get an average which is good,but as we have days not working what I would like to do is give a date should we have had continuous progress so i need to just have working days
does that make sence to you?

 

Upvote 0

BrianMH

Well-known Member

Joined

Mar 26, 2008

Messages

1,490

• Feb 26, 2014

• #10

So each day you put in the number of kilometres you do with the date you have done it. From what you describe the solution I provided in this post would do what you need. Can you explain why that solution does not work?

 

Upvote 0