DaniWeb Forum Index > Software Development > C#

format decimal value to time

Please support our C# advertiser: Programming Forums - DaniWeb Sister Site

Thread Solved

•

Join Date: Aug 2009

Posts: 40

Reputation: procomp65 is an unknown quantity at this point

Solved Threads: 0

procomp65

Offline

Light Poster

format decimal value to time

Sep 22nd, 2009

Hi
I need to format a decimal value to time and then display it in a textbox in the proper format. eg:
double value = 1.25 to "1:15"

I do not have a clue how to go about it

Thanks

•

Join Date: May 2009

Posts: 114

Reputation: papanyquiL is on a distinguished road

Solved Threads: 11

papanyquiL papanyquiL is offline

Offline

Junior Poster

Re: format decimal value to time

Sep 22nd, 2009

http://msdn.microsoft.com/en-us/libr...8VS.71%29.aspx

But you could do something like this...

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
double value = 1.25;
string str = Convert.ToString(value);
DateTime dt = Convert.ToDateTime(str);
textBox1.Text = dt.ToString();
double value = 1.25;
string str = Convert.ToString(value);
DateTime dt = Convert.ToDateTime(str);
textBox1.Text = dt.ToString();

And make a method to format the string so it displays just the time

Last edited by papanyquiL; Sep 22nd, 2009 at 4:41 pm.

•

Join Date: Aug 2009

Posts: 40

Reputation: procomp65 is an unknown quantity at this point

Solved Threads: 0

procomp65

Offline

Light Poster

Re: format decimal value to time

Sep 22nd, 2009

nope, that does not work
the output should be 1:15 and the output I get with your code is
AM 12:00

•

Join Date: May 2009

Posts: 114

Reputation: papanyquiL is on a distinguished road

Solved Threads: 11

papanyquiL papanyquiL is offline

Offline

Junior Poster

Re: format decimal value to time

Sep 22nd, 2009

•

And make a method to format the string so it displays just the time

Although, there might be an easier approach... Wait for more replies

•

Join Date: Aug 2009

Posts: 40

Reputation: procomp65 is an unknown quantity at this point

Solved Threads: 0

procomp65

Offline

Light Poster

Re: format decimal value to time

Sep 22nd, 2009

This is what I have sofar

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
public static string FractionalMinutesToString(decimal minutes, string format)
        {
            if (string.IsNullOrEmpty(format))
                format = "{0}:{1}"; TimeSpan tspan = TimeSpan.FromMinutes((double)minutes);
            return string.Format(format, tspan.Minutes, tspan.Seconds);
        }
        public static string FractionalHoursToString(decimal minutes)
        {
            return FractionalMinutesToString(minutes, null);
        }
 private void toolStripSplitButton1_Click(object sender, EventArgs e)
        {
 Double transitTime = Convert.ToDouble(subData1[13]);
                double newTransitTime = (transitTime * 0.1);
                transitTime = FractionalHoursToString(newTransitTime, );                
                txtTransmitTime.Text = transitTime.ToString();
}
public static string FractionalMinutesToString(decimal minutes, string format)
        {
            if (string.IsNullOrEmpty(format))
                format = "{0}:{1}"; TimeSpan tspan = TimeSpan.FromMinutes((double)minutes);
            return string.Format(format, tspan.Minutes, tspan.Seconds);
        }
        public static string FractionalHoursToString(decimal minutes)
        {
            return FractionalMinutesToString(minutes, null);
        }
 private void toolStripSplitButton1_Click(object sender, EventArgs e)
        {
 Double transitTime = Convert.ToDouble(subData1[13]);
                double newTransitTime = (transitTime * 0.1);
                transitTime = FractionalHoursToString(newTransitTime, );                
                txtTransmitTime.Text = transitTime.ToString();
}

•

Join Date: Oct 2008

Posts: 2,048

Reputation: ddanbe has much to be proud of

Solved Threads: 309

ddanbe

Offline

Postaholic

Re: format decimal value to time

Sep 22nd, 2009

Perhaps you can try this, it works with doubles but you can convert decimal to double.

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
class Program
    {
        static void Main(string[] args)
        {
            double DecNum = 13.573451;
            string TheTime = MakeTimeString(DecNum);
            Console.WriteLine(TheTime);
            DecNum = 1.25;
            TheTime = MakeTimeString(DecNum);
            Console.WriteLine(TheTime);
            Console.ReadKey(); // hold console until a key is pressed
        }
 
        static string MakeTimeString(double num)
        {
            double hours = Math.Floor(num); //take integral part
            double minutes = (num - hours) * 60.0; //multiply fractional part with 60
            //double seconds = (minutes - Math.Floor(minutes)) * 60.0;  //add if you want seconds
            int H = (int)Math.Floor(hours);
            int M = (int)Math.Floor(minutes);
            //int S = (int)Math.Floor(seconds);   //add if you want seconds
            return H.ToString() + ":" + M.ToString(); //+":" + S.ToString(); //add if you want seconds
 
        }
    }
class Program
    {
        static void Main(string[] args)
        {
            double DecNum = 13.573451;
            string TheTime = MakeTimeString(DecNum);
            Console.WriteLine(TheTime);
            DecNum = 1.25;
            TheTime = MakeTimeString(DecNum);
            Console.WriteLine(TheTime);
            Console.ReadKey(); // hold console until a key is pressed
        }

        static string MakeTimeString(double num)
        {
            double hours = Math.Floor(num); //take integral part
            double minutes = (num - hours) * 60.0; //multiply fractional part with 60
            //double seconds = (minutes - Math.Floor(minutes)) * 60.0;  //add if you want seconds
            int H = (int)Math.Floor(hours);
            int M = (int)Math.Floor(minutes);
            //int S = (int)Math.Floor(seconds);   //add if you want seconds
            return H.ToString() + ":" + M.ToString(); //+":" + S.ToString(); //add if you want seconds

        }
    }