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 |
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 |
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 |
All times are GMT +1. The time now is 05:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com