How to exclude lunch time from shifts

Question

1.00/5 (1 vote)

See more:

I have a Winform that divides out delivery time equally in a day. I have 6 textBoxes that I enter Lunch time for 3 shifts. I need it to exclude the start and stop time for lunch and pick up after so the times are still even. should i approach it differently like a csv file.

What I have tried:

I have searched the web with not luck on how to do it.

Posted 26-Nov-16 11:54am

Member 12349103

Updated 26-Nov-16 18:25pm

Add a Solution

2 solutions

Solution 1

Quote:
should i approach it differently like a csv file.

There is no different approaches, it is a mathematical problem, you only need to get the data by whatever mean you want. A csv file will not be simpler than TextBox, the only reason to choose one or the other us if lunch time change or not.

The work time is from Shift.begin to Lunch.begin and from Lunch.end to Shift.end. There shouldn't be any difficulties here.

Explain your problem of something is not clear for you.

[Update]

Quote:
have not seen a straight forward solution to subtract the times

First solution: you use DateTime variables that will handle details for you.
Second solution: you do it yourself. The digits on left of ":" are hours, the digits on right are minutes. Transform to minutes (1 hour= 60 minutes) a,d then subtract.

Posted 26-Nov-16 13:52pm

Patrice T

Updated 26-Nov-16 18:09pm

v2

Comments

Member 12349103 26-Nov-16 23:28pm

I can populate the information but have not seen a straight forward solution to subtract the times. I have been working on this for 2 mo. I'm new to code it could be done in a day for an experience coder. Thanks for the suggestion i will stay with text box.

Philippe Mori 5-Jan-17 14:57pm

DateTime and TimeSpan have all necessary functions and operators for basic time computation. If you would read the documentation, it would help you a lot.

Patrice T 5-Jan-17 15:10pm

So true.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 12349103 · Accepted Answer · 2016-11-26T17:29:00

C#

            var start_time = dateTimePicker1.Text;
            var start_time_array = start_time.Split(':');
            var today = DateTime.Now;
            var trailer_count = Convert.ToInt32(tbTrailer_Needed.Text);
            var minutes_apart = Convert.ToDouble(tbTime_Between.Text);
            var calculated_start_time = new DateTime(today.Year, today.Month, today.Day, Convert.ToInt16(start_time_array[0]), Convert.ToInt16(start_time_array[1]), 00);


var trailers = new List<trailer__time>();
            for (var i = 0; i < trailer_count; i++)
            {
                if (i == 0)
                {
                    calculated_start_time = calculated_start_time.AddMinutes(0);
                }
                else
                {
                    calculated_start_time = calculated_start_time.AddMinutes(minutes_apart);
                }

                trailers.Add(new Trailer__Time
                {
                    Trailer_Number = i,
                    Delivery_Time = calculated_start_time.ToString()
                });
            }

            dataGridView1.DataSource = trailers;
                    
        }