Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a calculation for browsing centre
giving one column in time
one column to out time conditions are Rs 5 for 15 minutes Rs10 for 30 minutes Rs 15 for 60 minutes Rs 75 for 20 minutes Rs 90for 25minutes can i make it in excel |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a calculation for browsing centre
You've left out some information. Can you give more detail?
-- HTH, Barb Reinhardt " wrote: giving one column in time one column to out time conditions are Rs 5 for 15 minutes Rs10 for 30 minutes Rs 15 for 60 minutes Rs 75 for 20 minutes Rs 90for 25minutes can i make it in excel |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a calculation for browsing centre
I agree with Barb. The table you provided is very confusing. The time values
goes up then down! Also, are the start and end data stored as real Excel time value like 7:45 AM ? Are you prepared to use a third column to compute each transaction and then use SUM to total the cells, OR must you have only one formula to do the entire computation? We want to help but need a clearer picture of the problem best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ... giving one column in time one column to out time conditions are Rs 5 for 15 minutes Rs10 for 30 minutes Rs 15 for 60 minutes Rs 75 for 20 minutes Rs 90for 25minutes can i make it in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Browsing to Hyperlink location | Excel Discussion (Misc queries) | |||
How do I get "centre across selection" to centre properly? | Excel Discussion (Misc queries) | |||
Browsing for a folder in "Look in:" | New Users to Excel | |||
Browsing for a folder in "Look in:" | Setting up and Configuration of Excel | |||
Browsing for a folder in "Look in:" | Excel Discussion (Misc queries) |