| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with calculation - Duration or Time multiplied by cost
I am so rubbish with Excel but can normally muddle by but I am stuck with
this one. I have a supplied spreadsheet that contain telephony information. The sheet contains a duration column (no formatting, just general) that contains figures like 00:00:44 and 00:15:48 I know that my per second billing is a value of 0.0166 Is there formula I can use to do duration * 0.0166 = cost ? I hope this makes sense.. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel calculation of duration in hours and minutes | Excel Worksheet Functions | |||
| time v cost calculation in Excel 2002 (XP) | Excel Discussion (Misc queries) | |||
| need to calculate time multiplied | Excel Worksheet Functions | |||
| Figure time multiplied by currency | Excel Worksheet Functions | |||
| Fixed Duration-strange calculation | New Users to Excel | |||
Threaded Mode
