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€¦
|