| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Price time to cost
Can any one please advise me how I can do the following
In A1 00:27:25 (which is time hh:mm:ss) In B1 0.488p ( which is the cost) In C1 - I have to charge the time by the cost but what ever I have done it does not work the same as doing via a calculator which I do not want to do as I have over 8,000 in my spread sheet. The above should come out to 13.29pence Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula using cost and margin % to get retail price? | Excel Discussion (Misc queries) | |||
| How can I calculate selling price from cost and GP? | New Users to Excel | |||
| Tracking Cost Price from Different Sheets | Excel Discussion (Misc queries) | |||
| Cost to Retail Price Formula - some help pse | Excel Worksheet Functions | |||
| formula for cost as percentage of sale price | New Users to Excel | |||
Threaded Mode
