| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation involving Time format
Hi chuck
try e1*d1*c1*24 Frank Chuck wrote: Hi Guys A1=01/01/04 9:00(Format dd/mm/yy 00:00:00) B1=01/01/04 10:00 (Format dd/mm/yy 00:00:00) C1 =B1-A1 (Format 00:00:00) D1=1.50 (Format $0.00) E1=50 (Format 0.00) F1=e1*d1*c1 Should be $75.00 but Im getting $3.12 How do I make it work? Thanks in advance Chuck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consecutive date calculation involving holidays | Excel Worksheet Functions | |||
| Formula help involving a Time value please. | Excel Discussion (Misc queries) | |||
| sum/division calculation involving vlookup with array? | Excel Worksheet Functions | |||
| Time format - problems with calculation | Excel Discussion (Misc queries) | |||
| 24 hour time format help with 00:00 calculation | Excel Discussion (Misc queries) | |||
Threaded Mode
