how do I convert an integer to hh:mm (part II)

G

Guest

Need to convert a simple integer (no decimals) to HH:MM format. The SQL
statement to convert this is as follows.... “select
datediff(mi,cast(cast(250/100 as int) as varchar) + ':' + cast(cast( 250 %
100 * .6 as int) as varchar)â€

Tried: =TIMEVALUE(TRUNC(250/100)&":"&MOD(250,100)*0.6)
but it returned a decimal value.

Any other suggestions?
 
D

Dave Peterson

Format it as time.

Format|cells|Number tab
Need to convert a simple integer (no decimals) to HH:MM format. The SQL
statement to convert this is as follows.... “select
datediff(mi,cast(cast(250/100 as int) as varchar) + ':' + cast(cast( 250 %
100 * .6 as int) as varchar)â€

Tried: =TIMEVALUE(TRUNC(250/100)&":"&MOD(250,100)*0.6)
but it returned a decimal value.

Any other suggestions?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I convert an integer to hh:mm in excel? 4
extract decimal and convert to integer 9
how to convert total hours (HH:MM) into decimal number 1
How to convert a date represented as a long in database 6
How do I convert an integer variable to a string variable? 2
How do I convert my dates to string in ADO 6
How do I convert char into integer in Excel VBA? 2
How do I convert string field to an Int and Date fields to store the data in the database? 2

Top