| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
Hi!
Divide by 24 and format the cell as [h]:mm =A1/24 = 17:30 Biff "Mike" wrote in message ... 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. |
|
#4
|
|||
|
|||
|
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" wrote in message ... 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. |
|
#5
|
|||
|
|||
|
Hi!
Use a format like [h]:mm:ss Biff "Mike" wrote in message ... 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" wrote in message ... 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. |
|
#6
|
|||
|
|||
|
Thanks!
"Biff" wrote: Hi! Use a format like [h]:mm:ss Biff "Mike" wrote in message ... 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" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
| Formula for time? | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Linear Mode
