to convert hours to minutes

Question

1.00/5 (2 votes)

See more:

Hello,
In a value1 column i have values like 9h , value2 column value is -4h10m , i need this all values to be converted into minutes for examples 2h means report has to show 120 m and -4h10m report has to show -250m

~~please send me the answer with explanation as soon as possible~~

Posted 10-Jun-15 21:32pm

G Senthil Kumar

Updated 10-Jun-15 21:44pm

Deepu S Nair

v2

Add a Solution

Comments

CHill60 11-Jun-15 3:42am

What have you tried?
What datatype are the columns?

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)

OriginalGriff · Answer 1 · 2015-06-10T22:06:00

Don't do that.
Change your database to either store a number of hours and a number of minutes, or just a number of minutes. And either way, don;t store numeric values in string based fields - they always cause hassle later on when you want to do anything useful with them, as you are starting to see.

Always store data in it's most appropriate types: Dates and times in DATE or DATETIME, numeric values in numeric fields. using string based storage is simple to set up and simple to insert, but it causes major problems later - particularly because it is very, very easy to get data which is not valid and as a result can;t be processed when it is needed - but that could be six months after the data was entered, when it's too late to work out exactly what the user intended.

Change your DB, change your software inserting values, and let presentation formatting be done at the time of presentation. Anything else is just propagating a problem further and further down the line and complicating software to the point it isn't worth maintaining.