+ Reply to Thread
Results 1 to 2 of 2

How to create a Cafe internet usage calculator worksheet...help please

  1. #1
    Registered User
    Join Date
    10-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to create a Cafe internet usage calculator worksheet...help please

    Hi, I don't want to invest in an expensive software for my cafe internet so i'm trying to build my own worksheet to calculate time, amount due.
    I'm posting a screen shot of what I'm trying to visually do. Here are some more details:Screen shot 2013-10-27 at 4.45.42 PM.png


    I want to keep it simple. I found a macro to make the "current time" cell running live and I programmed the button "PC 1" so when i click it, it prints the current time on start time. Now when i set to calculate the difference between START TIME and CURRENT TIME to calculate ELAPSED TIME (on D6 i have =D3-C6). IT shows ##########. I tried modifying it to hh:mm:ss but nothing... I'm guessing it's because Start time is a running clock. Anyone know a suggestion to make this happen? Anyone knows of a macro that would show both elapsed time and amount due running "live"?
    *The rate is $1 per 10 minutes up to 60 mins, then I stop charging because it's pay one hour get another free. No one spends more than 2 hrs.

    Thanks for anyone who can help me.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: How to create a Cafe internet usage calculator worksheet...help please

    Did you check to see if the column was wide enough. That is why it usually shows ########. However, I don't see why you need to use the whole "current time" cell. VBA has a build in current time definition. This is just a basic example showing how you would get the amount of time different. You would of course need to calculate for minutes and then to $$$$$

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate internet usage
    By boy_0708 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2012, 01:43 AM
  2. Does anyone have internet cafe software using Excel 2007 ?
    By bunnarong in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2011, 07:45 PM
  3. Excel 2007 : Create Paper Usage Report
    By dzuroff in forum Excel General
    Replies: 6
    Last Post: 04-06-2011, 10:18 AM
  4. Replies: 4
    Last Post: 11-17-2009, 05:50 PM
  5. "internet cafe log" spreadsheet
    By z-lite in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-19-2008, 01:02 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1