Convert Minutes into d:hh:mm:ss format

Question

0.00/5 (No votes)

See more:

ASP.NET

How to convert minutes into d:hh:mm:ss in asp.net or sql

Posted 18-Sep-11 22:27pm

Milind Panchal

Add a Solution

4 solutions

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)

johannesnestler · Answer 1 · 2011-09-19T05:02:00

OP wanted also seconds in the result, so I assume he wants to give a non integer number as minutes (like 120,75 minutes)
This is what I'd do:

1. Take a decimal number representing Minutes (and fractions)
2. Convert to "Ticks" = 100 nano seconds
3. Initialize TimeSpan with calculated ticks.
4. Convert to desired output format (ToString)

Here is a little Testapp:

C#

using System;

namespace MinutesToDateTime
{
    class Program
    {
        static void Main(string[] args)
        {
            double dMinutes = 120.75d; // Minutes as decimal number
            long iTicks = (long) (dMinutes * 60d * 10000000d); // Convert to Ticks
            TimeSpan ts = new TimeSpan(iTicks); // Initialize TimeSpan with calculated Ticks

            Console.WriteLine(ts.ToString("G")); // Convert To desired output format (see documentation for String.Format/ToString)

            Console.ReadKey();
        }
    }
}

sachin10d · Answer 2 · 2011-09-19T01:17:00

Solution 4

for Sqlserver

SQL

declare @min int
set @min = 1561
select @min / 1440  days,
(@min / 60) % 24 hours, 
@min % 60 minutes

Posted 19-Sep-11 1:17am

sachin10d

sachin10d · Answer 3 · 2011-09-19T00:29:00

Solution 3

Try this

C#

int min = DateTime.Now.Minute;
TimeSpan output = new TimeSpan(0,min,0);
string str = output.ToString().Replace(".",":");

Posted 19-Sep-11 0:29am

sachin10d

Muralikrishna8811 · Answer 4 · 2011-09-18T22:36:00

Hi,

Just now I write this.You've to add some additional code for it to get perfect output.Here just 'm giving idea on your question.

C#

int inp = int.Parse(TextBox1.Text);
      int d = 0, h = 0, min = 0, se = 0;
      d = inp / 1440;
      inp = inp % 1440;
      if (inp > 59)
      {
          h = inp / 60;
          inp = inp % 60;
          if (inp > 60)
          {
              min = inp / 60;
              inp = inp % 60;
              se = inp;
          }
          else
          {
              min = inp;
          }

      }
      else
      {
          h = inp;
      }

Try the above code for generating your requirement.In soon I'll post perfect code for it K

I hope u'll uderstand what I said.

Convert Minutes into d:hh:mm:ss format

4 solutions

Solution 5

Solution 4

Solution 3

Solution 1

Add your solution here

Preview 0