Demurrage Calculations

[emartinx]

Actual Arrival at Site Date / Time Actual Discharge Date / Time

Date Time Date Time
29-Nov-18 13:45 30-Nov-18 10:45
29-Nov-18 08:00 29-Nov-18 18:00
30-Nov-18 08:00 03-Dec-18 8:00

Notes:

* If arrival time is after 13:30, arrival time begins next day at 08:00.

* Demurrage charges accrue at the hourly rate until the daily rate cap is met (10 hours per day)

* figure demurrage at $10 per hour and daily rate cap of $100

 

[pecoflyer]

A little explanation, larger fonts and some courtesy are appreciated. Thx

 

[emartinx]

A little explanation, larger fonts and some courtesy are appreciated. Thx

I had issues lining up the items, thus the smaller fonts. The spread sheet has the same information. The problem I'm working involves deliveries. I have the date and time of arrival and the date and time of discharge (date and time shipper is offloaded). Here are the issues that are driving me nuts to write a formula for: (1) - If arrival of delivery is after 3:30, then the adjusted time of delivery is the following day at 8 AM. The delivery might actually be the same time and date so there is an issue with having the 4 hour free time being added to the arrival time. (2)Each delivery gets 4 hours (free time) being 4 hours that demurrage is not charged. (3) Demurrage charges accrue at an hourly rate of $10 per hour until they reach 10 hours in a day (day being 12 AM to 11:59 PM). Appreciate your assistance!! Solve for total hours that would be subject to demurrage in a formula (can contain steps with multiple formulas. )

 

[pecoflyer]

Your lack of courtesy ( no greeting or anything) does not incite me to help you.
I suppose someone else will. Cheers

 

[emartinx]

Your lack of courtesy ( no greeting or anything) does not incite me to help you.
I suppose someone else will. Cheers

LOL...sorry I did not give you that warm and fuzzy feeling...lack of courtesy or greeting?..If you want all that try facebook...I'm here to get help.

 

[emartinx]

Actual Arrival at Site Date / Time Actual Discharge Date / Time
Date Time Date Time
29-Nov-18 13:45 30-Nov-18 10:45
29-Nov-18 08:00 29-Nov-18 18:00
30-Nov-18 08:00 03-Dec-18 8:00

Notes:

* If arrival time is after 13:30, arrival time begins next day at 08:00.

* Demurrage charges accrue at the hourly rate until the daily rate cap is met (10 hours per day)

* figure demurrage at $10 per hour and daily rate cap of $100

A little explanation, larger fonts and some courtesy are appreciated. Thx

 

[vletm]

emartinx
No matter of font size ... if same information ...
Check this ( press that button )
and
try to give more details, if needs any/some modifications.

 

[emartinx]

emartinx
No matter of font size ... if same information ...
Check this ( press that button )
and
try to give more details, if needs any/some modifications.

Thanks...you are close....see attached that explains what the solution is however please provide formulas or steps with formulas that equal the solution. (The spreadsheet attached explains the solution. Again, thanks in advance for your efforts.

 

[vletm]

emartinx
1) I did that with Your original case (#1 Reply)
Seems that in Your #3 Reply has some NEW features,
I won't read that kind of texts NEVER!
Is there more missing features, which would change many things?
2) Your original case didn't give any idea of layout of results!
I could do something same as You, but what needs?
('Need' is different than 'nice-to-see')
3) Is the main difference, some 4hrs gap ... or how those results are different?
4) Are those $10 from every beginning or full hours?
Do that NEW 4hr gap include to that max 10hrs per day?
5) I won't use 'formulas' for this.
6) #1 .. 0/0 ... aren't hours in 30-Nov?

 

[emartinx]

emartinx
1) I did that with Your original case (#1 Reply)
Seems that in Your #3 Reply has some NEW features,
I won't read that kind of texts NEVER!
Is there more missing features, which would change many things?
2) Your original case didn't give any idea of layout of results!
I could do something same as You, but what needs?
('Need' is different than 'nice-to-see')
3) Is the main difference, some 4hrs gap ... or how those results are different?
4) Are those $10 from every beginning or full hours?
Do that NEW 4hr gap include to that max 10hrs per day?
5) I won't use 'formulas' for this.
6) #1 .. 0/0 ... aren't hours in 30-Nov?

Thanks for replying, I apologize for not mentioning the 4 hour free time but even still you would only been correct for problem #2. No new features. I thought that unless you had really thought about the steps you would be more apt to develop a formula. So what would you suggest as a solution? The real challenge is knowing the solution but being able to develop a formula or steps with formulas to arrive at the solution. That is even more challenging than not knowing the answer. LOL

 

[vletm]

Could You answer to those?
4) Are those $10 from every beginning or full hours?
Do that NEW 4hr gap include to that max 10hrs per day?
6) #1 .. 0/0 ... aren't hours in 30-Nov?

 

[vletm]

emartinx
My challenge is to get answers, that I could help without guessing.
Version 2.