|
Is there a clean and simple method of formatting an integer which is a count of a whole number of minutes into a decimal represnetation of hours and minutes. It's a great shame that there is not such thing as a timespan in T-SQL to support this.
Just ...
Answer Snippets (Read the full thread at stackoverflow):
To make the remainder appear to the right of the decimal place, divide the remaining minutes, you want to either take the total minutes mod 60 or the difference between the total by 100.0:
SELECT....
minutes and hours times 60.
|
|
I have some number of miles and a speed in MPH that I have converted into the number of hours it takes to travel that distance at that speed. Now I need to convert this decimal number into hours, minutes, and seconds. How do I do this? My best guess right...
Started by Jared on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Time = distance / speed; int hours = time; double minutesRemainder = (time - hours) * 60; int minutes = minutesRemainder; double secondsRemainder = (minutesRemainder - minutes) * 60; int seconds that back into hours/minutes/seconds....
|
|
Hi,
In my SQL query in Access 2000, I got a field containing numbers like:
0,15 1,30 1 0,50 Where x, is the hour, and ,xx is the minutes.
I need to convert this field into a DateTime (or the Access equivalent) field, because I later need to sum on the...
Started by Tommy Jakobsen on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Select_Time],","))) as [Total_....
You need to get the total minutes and convert to hours : minutes.
minutes:
• 0,15 -> 15 a datetime is going to do for you.
You could consider using an INTEGER value of a certain time granule e.g .
|
Ask your Facebook Friends
|
How to convert decimal degrees (example: 42.36824) to 42 deg., 22 min., 06 sec. in Visual Basic
Manual calculation
(1) The Degrees are simply the numbers to the left of the decimal (using 42.36824 as in the example above, the degrees would be 42)
(2) ...
Started by matrik02 on
, 11 posts
by 6 people.
Answer Snippets (Read the full thread at vbforums):
When Seconds are 60 set seconds to 0 and Minute +1, then do the same for minutes.
|
|
How do you convert a decimal number to mixed radix notation?
I guess that given an input of an array of each of the bases, and the decimal number, it should output an array of the values of each column.
Started by nickf on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
), 5(7), 7(24), 45(60), 15(60), 500(1000) and you want this converted to decimal:
Take number n %= placeValues[v]; } console.log(output); // [97, 52, 8, 15, 3] --> 3 days, 15 hours, 8 minutes.
|
|
What i need to do, is have two defined strings that is inputted by the user,
string in = "9:35"; //am string out = "11:55"; //am
and i need to subtract them, so that would get the total hours that they were signed in. which should equal:
string total ...
Started by Xavier on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
How about TimeSpan(11, 55, 0); //or TimeSpan.Parse....
Those will be the minutes, so just add them to the hours.
Take the remainder of the decimal and multiply by 60, then round.
Wanted to go back, you'd just need to do a little bit of math .
|
|
Note: For brevity's sake, the following will not discern between randomness and pseudo-randomness. Also, in this context, 'constrained' means 'between given min and max values')
The System.Random class provides random generation of integers, doubles and...
Started by Jackie Chiles on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For decimal I utilized Jon Skeet's initial approach to generating....
This should do it.
Generating a random decimal is signficantly harder, I believe - aside from anything else, you'd have to specify the distribution you wanted.
The base.
|
|
I have the following code:
SN.get_Chars(5)
SN is a string so this should give the 5th Char Ok!
Now i have another code but : SN.get_Chars(0x10)
I wonder what 0x10 is? Is it a number? If it's so, then what is it in decimal notation?
Started by Omar Abid on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
It's a hex number and is 16 decimal of 60 seconds/minutes in the minute/hour, 360 degrees in a circle, 60 minutes (of arc) in a degree' is the representation of ....
0x10 is 16.
X means the number is hexadecimal , or base 16 .
|
|
I have an hour field in a database like 1.4, 1.5, 1.7 that I need to convert back to HH:MM. What is the easiest way to do this?
Started by Tony Borf on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
To get the minutes figure, subtract the whole number portion so you only have the amount after the decimal, then multiply the fraction by 60 to get the minutes....
The HH (hour) figure is the number before the decimal.
To the console.
|
|
On Thu, 6 Nov 2008 11:28:04 -0800, Dave <Dave@discussions.microsoft.com
I have a decimal value into hours and minutes.
The decimal value of 1.09 should equal 1:05
Is there a function to do this?
Thanks
Started by Dave on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
On Thu, 6 Nov 2008 14:39:43 -0500, "Michel Walsh" <vanderghast@VirusAreFunnierThanSpam
If it is less than 24 hours (and greater than 0), you can try:
Format( x / 24.0, "hh:nn:ss")
such as
? Format( 1.09 / 24.0, "hh:nn:ss" )
not that it ... .
|
