Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() I am currently trying to convert hours to minutes or numbers to minutes... for example if I take 1127 -812, I get either 315 general number or 3:15 in time format (if all numbers are in time format)... if I go this way, I would like to convert the time to show minutes or 105 as a general number. The other way would be to keep the general number, but then this problem occurs... 1002-926=76, when in fact it is 36 minutes. overall, I am looking at only inputing numbers in 2 colums and 10 rows... would like to keep it to simple number input in all coulms and rows as well as final answer as it will be used regularly by other people. any ideas? Thanks Jerry -- herosuper |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
converting hours to hours & minutes | Excel Discussion (Misc queries) | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions |