how do I convert an integer to hh:mm in excel?
 

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)€�

Trying to get the formula format correct in XCel. If you have any ideas that
would be great€¦

how do I convert an integer to hh:mm in excel?
 

=TIMEVALUE(TRUNC(250/100)&":"&MOD(250,100)*0.6)

--
Regards,
Tom Ogilvy


"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)€�

Trying to get the formula format correct in XCel. If you have any ideas that
would be great€¦

how do I convert an integer to hh:mm in excel?
 

Tom,

Where do I put in the cell value (ex: A1) that I'm wishing to convert?

Thanks,
Kim

"Tom Ogilvy" wrote:

=TIMEVALUE(TRUNC(250/100)&":"&MOD(250,100)*0.6)

--
Regards,
Tom Ogilvy


"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)€�

Trying to get the formula format correct in XCel. If you have any ideas that
would be great€¦

how do I convert an integer to hh:mm in excel?
 

Tom,

This gives a decimal number back... any other suggestions?

Kim


"kdell" wrote:

Tom,

Where do I put in the cell value (ex: A1) that I'm wishing to convert?

Thanks,
Kim

"Tom Ogilvy" wrote:

=TIMEVALUE(TRUNC(250/100)&":"&MOD(250,100)*0.6)

--
Regards,
Tom Ogilvy


"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)€�

Trying to get the formula format correct in XCel. If you have any ideas that
would be great€¦

how do I convert an integer to hh:mm in excel?
 

format it as time.

kdell wrote:

Tom,

This gives a decimal number back... any other suggestions?

Kim

"kdell" wrote:

Tom,

Where do I put in the cell value (ex: A1) that I'm wishing to convert?

Thanks,
Kim

"Tom Ogilvy" wrote:

=TIMEVALUE(TRUNC(250/100)&":"&MOD(250,100)*0.6)

--
Regards,
Tom Ogilvy


"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)€�

Trying to get the formula format correct in XCel. If you have any ideas that
would be great€¦


--

Dave Peterson