Search results

The problem is solved. Should I close the thread somewhere?

Thanks. An even simpler solution

Thanks, works perfect

Hi. I am wondering how to force the result of a formula to only show multiples of a certain number. For example. If the multiple =6, and the formulas result is 4.5, it should display 6. If the result is 7.5, it should display 12 1.2 => 6 5.5 => 6 6.5 => 12 8 => 12 11.5 => 12 14 => 18 18.2 => 24...

Sorry, I missed that this finishtime was at a weekend. My misstake, it works fine within shop hours

Sorry, missed that. My misstake, it works fine within shop hours

Hi. I found a missmatch between P45cal & Narayan's model Finish 2017-11-04 09:00 runtime 19:30 open 07:00 close 16:45 Result: Narayan 2017-11-01 16:45 P45cal 2017-11-02 16:45 They are 1 day apart at this specific scnenario. I believe P45cal's is miscalculating this time

Now I have tested Narayan against p45cal for a complete week, using run times 00:20, 09:30, 55:25 and both methods shows the same results. (Vietm's solution looped for me at 00:20 so I had to remove it from the comparsion). I will work with the data during the weekend, and hopefully we are done...

I entered a low runtime in Narayan's model (00:20), and it calculated the start time as being > finish time, so something is still wrong there

Thanks to all 3 of you: Narayan, P45cal & Vletm

I can fix that by extending the number of columns, looks great. thanks a lot!

It seems to be working just fine! You are a star!! Now the last thing. I need to be able to enter a runtime > 23 hours. Is that possible to fix?

To reply to your question 2: Yes, that would work fine

Hi. I looked further into checking the calculations. I have made "Manual" calculattions of the total time used for different cases (In rows BF_BU) The first 5 works correct, the I skipped those with the previously detected error, and then there are miscalculations again. Please check and see if...

Thanks. I have tested and the formula crashes when the finishtime is earlier the the opening hours of the shop. I have extended the fomulas to a table with different starting time over a week with 2 hours incremental steps, and done a gant-chart to grafically graps what is happening. Please have...

I am trying to plan backwards based on the followingas input: - Planned finish time (yy-mm-dd hh:mm) - Runtime (hh:mm) [Time it takes to manufacture the widget] - Shop opening time (hh:mm) - Shop closing hours (hh:mm) What I am looking for is a formula that can calculate backwards to a planned...