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
From Pakistan, Gujranwala
Acknowledge(0)
Amend(0)
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
From Pakistan, Gujranwala
Acknowledge(0)Amend(0)
1189CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee excel sheet.xls