Planning to Open a Net Cafe? Here's How to Use Excel for Tracking Hours and Payments

I want to run a Net Cafe soon. I want to create an Excel worksheet to calculate hours and receive payments from customers who use the internet. My requirements are as follows:

1) Time In
2) Time Out
3) Total Hours of Internet Usage
4) Rate per Hour
5) Total Amount

Calculation of Total Amount

After that, I want to calculate the same categories (Total Amount) on a daily and monthly basis, along with expenses.

Required Formula

Thanks,
Naveed Rahmat

Welcome to the knowledge-sharing forum! Here, you can learn a lot and share whatever you know. I have attached a file for your reference. You can create your own by using this file as a base.

Regards