View Full Version : Converting minutes to houres & minutes

Vince

08-06-2013, 11:47 AM

Here's one that Google cant answer!

I have a large DVD collection and I have to constantly convert the movie length's from "minutes" to the more comprehensible Hours and minutes.

My mental resources are maximized; any unnecessary load is to be avoided.

That is why I am looking for a way to do the conversion from something like 257 minutes to 4:17 Hours & minutes.

Does anybody know how this can be done in a vary few steps?

wainuitech

08-06-2013, 12:35 PM

Don't know if I'm reading that right, but those figures aren't correct anyway. 257 Minutes is actually 4.28 hrs not 4.17.

Its simple maths really, take the minutes divide by 60 = hours/minutes, and in reverse hrs+minutes X 60 will give you the minutes.

OR If you want to be accurate theres MANY free converters available - Heres one (http://www.calculateme.com/Time/index.htm) same site minutes to hours Minutes To Hours (http://www.calculateme.com/Time/Minutes/ToHours.htm)

pcuser42

08-06-2013, 12:41 PM

Hours = total minutes / 60

Minutes = total minutes modulo 60

If you have a calculator that can work out the modulo (remainder after a division) it's a simple calculation.

bevy121

08-06-2013, 01:23 PM

Don't know if I'm reading that right, but those figures aren't correct anyway. 257 Minutes is actually 4.28 hrs not 4.17.

Its simple maths really, take the minutes divide by 60 = hours/minutes, and in reverse hrs+minutes X 60 will give you the minutes.

OR If you want to be accurate theres MANY free converters available - Heres one (http://www.calculateme.com/Time/index.htm) same site minutes to hours Minutes To Hours (http://www.calculateme.com/Time/Minutes/ToHours.htm)

He doesn't want the remainder minutes in decimal fractions of an hour

As he said - he wants mins to hours and minutes.

...which is 4 hours and 17 minutes

Vince

08-06-2013, 01:46 PM

He doesn't want the remainder minutes in decimal fractions of an hour

As he said - he wants mins to hours and minutes.

...which is 4 hours and 17 minutes

Hey, someone actually read what I wrote. Good on you! :)

Vince

08-06-2013, 01:56 PM

Don't know if I'm reading that right, but those figures aren't correct anyway. 257 Minutes is actually 4.28 hrs not 4.17.

Its simple maths really, take the minutes divide by 60 = hours/minutes, and in reverse hrs+minutes X 60 will give you the minutes.

OR If you want to be accurate theres MANY free converters available - Heres one (http://www.calculateme.com/Time/index.htm) same site minutes to hours Minutes To Hours (http://www.calculateme.com/Time/Minutes/ToHours.htm)

I did say, "Here's one that Google cant answer!"

That should have told you that I had already checked out those sites.

That first link of yours goes to a site that gives hours and tenths of hours.

It would have been better if you hadn't wasted our time on something you hadn't checked out first.:)

inphinity

08-06-2013, 02:03 PM

(int(t/60)) : (t%60) where t is total minutes.

wainuitech

08-06-2013, 02:49 PM

I did say, "Here's one that Google cant answer!"

That should have told you that I had already checked out those sites.

That first link of yours goes to a site that gives hours and tenths of hours.

It would have been better if you hadn't wasted our time on something you hadn't checked out first.:) Before you go accusing anyone of wasting time maybe you should read what was put, that's why I said If I was reading it right.

The way you wanted it, is simple to work out even without the use of a calculator or any other such functions, simple maths. Ever think the reason you cant find the answers as you wanted on google is because its giving false real times.

highlighted in the quote -- Who died and made you the supreme leader of everything.

b....

08-06-2013, 05:35 PM

http://minutestohours.com/

Vince

08-06-2013, 05:49 PM

http://minutestohours.com/

Hey, thanks one that works! If only I could download it.

Whats wrong with using it from the internet ?

bevy121

08-06-2013, 06:12 PM

Hey there Vince - with such a great name that you have (Guess what mine is! lol) I thought I'd code a quick app for you :)

you will need dot net framework to use it, but you will probably have it allready even if you dont know if you have or not lol.

If you would like it customized or more functions added or something just let me know, I'm always keen for making bits and pieces :)

here is the download link for you (www.thestudio69.com/kiwi1/Minute Convertor.exe)

Billy T

09-06-2013, 12:00 AM

Jeez you guys make it complicated!

The basic error that started all this palaver was a simple failure to recognise that by convention in writing, the hours and minutes are separated by a colon, not a period, the latter being easily mistaken for a decimal point (as indeed it was at one stage above).

Thus: 4:17 = 4 hrs 17 minutes.

I'm no mathematical whiz, in fact at College I was so bad at maths that my classes stopped when I was 14, but there cannot be too many people out there today who don't know the basic multiplication tables, unless 'new math' abolished them in favour of obfuscation and calculators.

The whole calculation is basic mental arithmetic 4 x 60min =240, 240 +17 =257minutes.

In a practical sense, 257 minutes becomes 4 x 6 = 24 = 240 minutes +17 = 4 hours 17 minutes

As another example 194 minutes becomes 3 x 6 = 18 = 180minutes +14 = 3 hours 14 minutes

Once you have a method, it becomes simple, just use the six-times table to get the first two numbers.

Computer programs are unnecessary, unless perhaps the user suffers from some type of number blindness, in which case they might still have a problem with any form of calculator, be it computer based or otherwise.

Cheers

Billy 8-{)

dugimodo

09-06-2013, 10:32 AM

Yeah I don't see the problem either I just do it in my head. There are only realistically 4 numbers to remember and 3 would do most of the time, i.e. 60, 120, 180, 240 = 1, 2, 3, and 4 hours respectively. You Just choose the largest value that goes into your total number of minutes and that gives you the hours, then subtract it from the total for the minutes.

So simple subtraction does the Job, 257 = 240 ( 4hours ) + (257-240=17) minutes. I could make an excel formula to do it for me in about 30 seconds.

Like this, put the input in A1, make A2 have the formula =int (A1/60), make A3 have the formula =A1-A2*60 and you have a column with hours and a column with minutes. Change all the As to Bs and put a title row in and it's even easier to use.

Several other people have explained the same thing in different ways and inphinity seems to have done it in a much more compact formula, I don't know the T%60 part myself and tend to break my formulae into small easy to understand steps as above.

pcuser42

09-06-2013, 11:05 AM

Jeez you guys make it complicated!

How did I make it complicated? Simple division on a calculator :p

Vince

13-06-2013, 09:31 PM

Yeah I don't see the problem either I just do it in my head. There are only realistically 4 numbers to remember and 3 would do most of the time, i.e. 60, 120, 180, 240 = 1, 2, 3, and 4 hours respectively. You Just choose the largest value that goes into your total number of minutes and that gives you the hours, then subtract it from the total for the minutes.

So simple subtraction does the Job, 257 = 240 ( 4hours ) + (257-240=17) minutes. I could make an excel formula to do it for me in about 30 seconds. .

It's easy to do once or twice, but when I spend 2 or 3 hours filling in the information for a couple of dozen titles, it becomes tiresome to say the least. Near the end of a session it makes my head spin.

Thanks bevy121:)

kahawai chaser

13-06-2013, 10:13 PM

A computational engine like Wolfram Alpha (http://www.wolframalpha.com/) maybe want you want...

Vince

14-06-2013, 08:07 AM

A computational engine like Wolfram Alpha (http://www.wolframalpha.com/) maybe want you want...

The little utility that bevy21 wrote for me is just right.

A candidate for the new site that I suggested here;_http://pressf1.pcworld.co.nz/showthread.php?133823-I-d-like-to-propose-a-new-forum.&p=1168084#post1168084

bevy121

15-06-2013, 04:41 PM

Hi Vince - glad to hear my wee tool is useful :)

I have done what you asked and displayed the results in the same pane below the input box

Also filtered out any non digits from being entered, or an empty number field

Made the enter key perform the "convert" function as well.

auto clears the input and sets curser focus back after converting

larger text for the result

and should trap most errors now as well

Any thing else just let me know

Here's the updated one for you to download (www.thestudio69.com/kiwi1/Minute_Convertor2.exe)

Vince

15-06-2013, 05:01 PM

Thankyou Bevy121. I appreciate it very much.:)

I wish I could do coding, but my resources are fully committed.

Vince

15-06-2013, 05:59 PM

Thankyou Bevy121. I appreciate it very much.:)

.

It's just right. Thanks again.

Vince

Powered by vBulletin® Version 4.2.5 Copyright © 2019 vBulletin Solutions Inc. All rights reserved.