Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet and in one column in says 66.5 - that's the time it
takes me to run x amount of miles. I did a formula to divide that answer by 60 because I want to show the answer in hours and minutes and it comes out as 1.11. I gather the .11 is part of an hour but how do I display it as 1 hour 6 minutes? Thanks v. much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Response Time | Excel Discussion (Misc queries) | |||
calculating time | Excel Discussion (Misc queries) | |||
help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |