| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formula
That was just to obvious I should of seen that, Thank you.
"Mike H" wrote: and Mike H where does 96 come from? There are 96 quarter hours in a day "jockj215" wrote: Thanks both seem to be good ways round problem, Teethless mama I thought mround would work will need to get IT to add to my computer at work can i ask where does 93.6 come from? and Mike H where does 96 come from? Me a bit thick with these things so appreciate the help. as the £3.90 is the hourly cost and is due for review so may change soon. "Teethless mama" wrote: =MROUND(B1-A1,TIME(,15,))*93.6 Format cell as General "jockj215" wrote: Hi I have a small problem which should be easy to do but frustrating me just a bit. I have some pool cars with different departments which need to be charge for their use. I get weekly sheets in with start time and end time of use. i.e. A1 08:45 B1 10:25 I need to calculate as follows C1 time car used to nearest 15 minutes. D1 cost of use (C1*3.90). Should be easy but I think I am making hard work of this and am sure there is a simple answer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Threaded Mode
