ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   need a calculation for browsing centre (https://www.excelbanter.com/excel-worksheet-functions/171064-need-calculation-browsing-centre.html)

[email protected]

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


Barb Reinhardt

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



Bernard Liengme

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