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…

=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…
>

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…
> >

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…
> > >

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