| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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€¦ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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€¦ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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€¦ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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€¦ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| 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 char into integer in Excel VBA? | Excel Discussion (Misc queries) | |||
| Convert Text to Integer | Excel Discussion (Misc queries) | |||
| Convert time into integer | Excel Worksheet Functions | |||
Linear Mode
