Time Calculation Formula!

[Mike]

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.

 

[Damon Longworth]

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

 

[Biff]

Hi!

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

=A1/24 = 17:30

Biff

 

[Mike]

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

Hi!

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

=A1/24 = 17:30

Biff

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.

 

[Biff]

Hi!

Use a format like [h]:mm:ss

Biff

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

Hi!

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

=A1/24 = 17:30

Biff

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.

 

[Mike]

Thanks!

Hi!

Use a format like [h]:mm:ss

Biff

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

Hi!

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

=A1/24 = 17:30

Biff

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.