# Challenge - Excel for Internet Cafe

#### pravin_av

##### New Member
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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hmmm i don't think calling someone a geek is the best way to ask for help do you?

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

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

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

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

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

Replies
9
Views
231
Replies
0
Views
478
Replies
5
Views
389
Replies
3
Views
489
Replies
3
Views
387

1,196,484
Messages
6,015,466
Members
441,898
Latest member
kofafa

### 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.

### Which adblocker are you using?

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

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