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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
run stored proc from excel with a parameter 1
returning data from a Stored Procedure 2
Getting the weeknumber 4
extract decimal and convert to integer 9
Concatenating Numbers/Converting Dates to Integers 1
Clicks Conversion 1
how to convert total hours (HH:MM) into decimal number 1

Back
Top