Challenge - Excel for Internet Cafe

pravin_av

New Member
Joined
Oct 7, 2002
Messages
2
Hello
I own a internet cafe with 14 cabins.
I created a simple sheet like this with columns
A | B | C | D | E
1 |cabin no.|time-in |time-out|net-time|rate|
2 | a| 9.15 | 9.30 | 0.30 | $10
3 | b| 9.30 | 9.45 | 0.15 | $10
4 | e|10.30 | - |#######|-




note : there are (a-n)-14 cabins. in a instance only one cabin will be alloted to a user.
In above example cabin a and b are free now but there exist a user in e

for ref the formula in D id =(C$-B$)

for the above scenario i need to know
question no 1:
--------------
i need to know how many cabins are free (not filled with customers) i know nothing about macros. can any one help me

question no 2:
--------------
referring above the rate shoul be automatically calculated as follows
1 - 30min - $10
30min - 1Hour - $20
ie for every 30 min I charge 10bugs ( I live in India)

any geeks to help ...thanks in advance
This message was edited by pravin_av on 2002-10-08 13:45
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Hmmm i don't think calling someone a geek is the best way to ask for help do you?
 
Upvote 0
Number available with a simple formula

=14-(COUNTIF(B1:B100,">0")-COUNTIF(C1:C100,">0"))

If times are in cells

d2 =(C2-B2)*24

e2 =CEILING(D2,0.5)*20

Use Custom Number Format to add your "R".
With calculations that yield 0,
- modify the formula to yield "" or
- use custome format number or
- set option to hide 0
This message was edited by Dave Patton on 2002-10-08 19:27
 
Upvote 0
Question 2 is solved by using the vlookup function.
Length of time rate
0:00 0:30 10
0:31 1:00 20
1:01 1:30 30
1:31 2:00 40
2:01 2:30 50
2:31 3:00 60
 
Upvote 0
Hi Pravin_av:

Please note the formulas for computations for Chargable time, Charge in Rs, and the Number of Booths available at any given point in time in the following worksheet simulation.
y021008.xls
ABCDEFGH
1cabinNoTimeInTimeOutNetTimeCharge
2a9:009:300:3010RsNumberofBoothsAvailable13
3b9:309:450:1510Rs
4c10:30  labels
5d23:001:002:0040RsCafOperatorInput
6e  computed
7f  
8g  
9h  
10i  
11j  
12k  
13l  
14m  
15n  
Sheet5


Regards!

Yogi
 
Upvote 0
Hello Everybody,


My heartfelt gratitude to every one who helped me, to mention here dave,njbean and especially Mr.Yogi Anand thanks a ton.
I'll try every bit of your suggestions and let you know about the proceedings.



bolo kindly note:Geek,to me I thought was a expert thats all . i apologize if I did hurt you.

See you soon friends
Thanks once again for the help.
Pravin
:)
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top