How to calculate time

Question

0.00/5 (No votes)

See more:

Hi all

In my application i have to generate a sales report.

In that the form will have below 2 things

Start time - ComboBox(e.g 10:00 am)
time span - ComboBox(e.g 20)

Start time is like for a particular store there day starts at 10:00 am
and span is they calculate there day as 20 hours starting from 10:00 am.

so i have to generate the sales report starting from 10:00 am + 20 hour

e.g if the user select date as 18-01-2014
Start time 10:00 am
Time span 20 hours

so it should give the report from 18-01-2014 10:00 am to 19-01-2014 6:00am

Please need some ideas how to approach..

Thank you

Posted 17-Jan-14 17:11pm

Snehasish_Nandy

Add a Solution

1 solution

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)

Karthik_Mahalingam · Answer 1 · 2014-01-17T17:32:00

Solution 1

Try like this..

C#

string date = "18-01-2014"; // get from combobox
            string time = "10:00 am"; // get from combobox
            string timespan = "20"; // get from combobox

           double span = Convert.ToDouble(timespan);
           string input = string.Format("{0} {1}",date,time);
          DateTime startTime =  DateTime.ParseExact(input, "dd-MM-yyyy hh:mm tt", null);
          DateTime endTime = startTime.AddHours(span);

          Console.WriteLine(startTime);
          Console.WriteLine(endTime);

Posted 17-Jan-14 17:32pm

Karthik_Mahalingam

Comments

Mitchell J. 17-Jan-14 23:36pm

Nice solution :-)

Karthik_Mahalingam 17-Jan-14 23:38pm

thanks craig :)

[no name] 17-Jan-14 23:59pm

Thanks KARTHIK..i will check and reply back to you..

Karthik_Mahalingam 18-Jan-14 0:05am

sure SN :)