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

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

From Pakistan, Gujranwala
Acknowledge(0)
Amend(0)

boss2966
1189

Dear Naveed Rahmat,

First of all, let me welcome you on behalf of CiteHR Members 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.

From India, Kumbakonam
Attached Files (Download Requires Membership)
File Type: xls Excel Format.xls (32.0 KB, 12515 views)

Acknowledge(0)
Amend(0)

Hi Please send me the daily work report format as per Department.
From India, Ahmedabad
Acknowledge(0)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.