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

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

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

Guest

Tom,

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

Thanks,
Kim
 

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 (part II) 1
returning data from a Stored Procedure 2
run stored proc from excel with a parameter 1
How to convert a date represented as a long in database 6
how to convert total hours (HH:MM) into decimal number 1
Can I convert hh:mm to mm in Excel 1
Stored procedure exception in .NET works fine in Query Analyzer 9
Convert HH:MM to seconds 2

Top