Time Calculation Formula!

I have a program that gives me time in whole number format. ie 17.5 hours. I
need to know how to I create a formula that would turn that in actual hours
and minutes.

If you divide 17.5 by 24, you will get a time equal 17:30.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Mike" <[email protected]> wrote in message
news:[email protected]...
>I have a program that gives me time in whole number format. ie 17.5 hours.
>I
> need to know how to I create a formula that would turn that in actual
> hours
> and minutes.

Hi!

Divide by 24 and format the cell as [h]:mm

=A1/24 = 17:30

Biff

"Mike" <[email protected]> wrote in message
news:[email protected]...
>I have a program that gives me time in whole number format. ie 17.5 hours.
>I
> need to know how to I create a formula that would turn that in actual
> hours
> and minutes.

Thank you so much! Also, what do I need to do to show Hr:Min and seconds

"Biff" wrote:

> Hi!
>
> Divide by 24 and format the cell as [h]:mm
>
> =A1/24 = 17:30
>
> Biff
>
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> >I have a program that gives me time in whole number format. ie 17.5 hours.
> >I
> > need to know how to I create a formula that would turn that in actual
> > hours
> > and minutes.
>
>
>

Hi!

Use a format like [h]:mm:ss

Biff

"Mike" <[email protected]> wrote in message
news:[email protected]...
> Thank you so much! Also, what do I need to do to show Hr:Min and seconds
>
> "Biff" wrote:
>
>> Hi!
>>
>> Divide by 24 and format the cell as [h]:mm
>>
>> =A1/24 = 17:30
>>
>> Biff
>>
>> "Mike" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have a program that gives me time in whole number format. ie 17.5
>> >hours.
>> >I
>> > need to know how to I create a formula that would turn that in actual
>> > hours
>> > and minutes.
>>
>>
>>

Thanks!

"Biff" wrote:

> Hi!
>
> Use a format like [h]:mm:ss
>
> Biff
>
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> > Thank you so much! Also, what do I need to do to show Hr:Min and seconds
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> Divide by 24 and format the cell as [h]:mm
> >>
> >> =A1/24 = 17:30
> >>
> >> Biff
> >>
> >> "Mike" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >I have a program that gives me time in whole number format. ie 17.5
> >> >hours.
> >> >I
> >> > need to know how to I create a formula that would turn that in actual
> >> > hours
> >> > and minutes.
> >>
> >>
> >>
>
>
>