Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
i'm creating invoices from cost sheets.
in order to hide the 'true' mark up (profit) i have to inflate the labour (time taken) however how more oftenthan not i end up with a figure that is not divisible by a time unit such as, 3 hours, or 3.25 hours, 4.75 hous ......must be quarter of an hour increases etc. what formulae might one create, to make a monatary figure relate to a time figure in .25 units (15 minutes) example a sum of £88.23 divided by labour rate of £27.00 = 3.26666666 ideally this time figure should be 3.25 hours or, 3.5 hours.... ideas? regards Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formulae | Excel Discussion (Misc queries) | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
using formulae in excel | Excel Worksheet Functions | |||
excel formulae | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |