| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert & multiply (number & time)formulas
I need help with a couple of issues in the same table.
-the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert time stored as decimalised number to time format | New Users to Excel | |||
| How to: Convert time value to a number | Excel Worksheet Functions | |||
| Convert number to time | Excel Discussion (Misc queries) | |||
| Convert a number to a time | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
