Results 1 to 12 of 12
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to count this.. (2000)

    Hello again guys ,

    I need to count the duration of a student using pc in the school lab

    Then i have to charge them ..

    But the formula i i use cannot do this..

    I dint know how to elaborate it correctly..

    Please refer to the attachment..thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to count this.. (2000)

    How do you want to charge? For example, if somebody uses the PC for 40 minutes, do you charge 40/60 of the hourly charge, i.e. 40 cents? Or do you round up to the nearest whole hour, i.e. you charge 1 hour = 60 cents?

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to count this.. (2000)

    Thanks hans for the reply,

    yes, i want according to the hourly charge..ie..if they use it 40 minutes, then they have to pay it 40 cents

    if they use it 70 minutes aka 1 hour and 10 minutes ..they have to pay it 70 cents..

    any idea ? thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to count this.. (2000)

    Format the start, end and duration cells as time. The duration is simply the difference between end and start time.
    Since Excel stores times as fractions of 1 day, you must multiply the duration by 24 to get hours, then by the hourly rate.
    See attached, modified version.

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to count this.. (2000)

    Thanks hans..

    But why is is the times in cell a4. everytime i try to change the time..let say 1.00 , it always show back to 12.00 am..the same goes to the "end " cell

    what am i doing wrong..thanks

    ps: i did not change the formats of the cell...

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to count this.. (2000)

    Excel must be able to recognize the value you enter as a time. You can enter 1 PM or 13:00.

  7. #7
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to count this.. (2000)

    thanks again hans..

    i try to enter 1 pm and it works..i try to enter 1.30 pm and it didnt works..

    cant we just store the time using number like "start" 1 and "end" 2.30 and and count it,,,thanks

    using the format for me is pretty annoying and pretty confusing..any idea hans ?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to count this.. (2000)

    Excel uses the character defined as time delimiter in the Regional Settings control panel. In English-language versions, the default is the colon :
    This is the character you must use when entering time, e.g. <code>1:30 PM</code>.

    If you were to use ordinary numbers to enter the time, it would be easy to enter incorrect values. For example, 1.98 does not correspond to a valid time. Moreover, the formulas would become much more complex, because you would have to do all the conversions from hour/minute to decimal yourself.

  9. #9
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to count this.. (2000)

    thanks hans for the explanation..

    now , i really know it works..regards

  10. #10
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to count this.. (2000)

    Hello again hans..

    after a make a lot of thinking , something appaeras to my mind..

    how for me to set the charge to display in dollar and cent..something like when there is 50 cent , it will shows

    $0.50 and etc..and i want to increased the charge..let say $2.00 per hour

    please refer to attachment again..thanks

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to count this.. (2000)

    Set the format for the cells containing amounts of money to a currency format. Just enter 2 in the hourly rate cell. See attached.

  12. #12
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to count this.. (2000)

    thanks hans..it works...regards...

Posting Permissions

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