Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Integer convert to minutes. | Excel Discussion (Misc queries) | |||
Convert integer to time query | Excel Discussion (Misc queries) | |||
how do I convert an integer to hh:mm in excel? | Excel Programming | |||
Convert Text to Integer | Excel Discussion (Misc queries) | |||
Convert time into integer | Excel Worksheet Functions |