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

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?

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

Format it as time.

Format|cells|Number tab

kdell wrote:

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?

--

Dave Peterson