| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Min & Hrs to Min in Decimal
I'm pasting text into excell & need a decimal count of minutes. The problem
comes in that some text is refering to hours and sometimes to minutes & I can't come up with a formula to handle both. Ex: Paste the following A1 - 2:00 A2 - 3:00 A3 - 3:00:00 A4 - 3:40:00 Should convert to A1 = 2 A2 = 3 A3 = 180 A4 = 220 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
| convert decimal to 16 bit hex | Excel Worksheet Functions | |||
| Convert Hrs:Min to Decimal Hrs | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| hex to decimal convert | Excel Worksheet Functions | |||
Threaded Mode
