Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time formula
how to calculate a cell time format with cell currency format.
for example, I want that 00:01:00 = $1.00 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
time formula
Cell A1 is 00:01:00
Cell A2 is =A1*24*60, and format it as currency $ -- Allllen "flvo" wrote: how to calculate a cell time format with cell currency format. for example, I want that 00:01:00 = $1.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel calculate time increments in a formula? | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |