# Thread: How to count this.. (2000)

1. ## 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..

2. ## 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. ## Re: How to count this.. (2000)

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. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: How to count this.. (2000)

thanks hans for the explanation..

now , i really know it works..regards

10. ## 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

11. ## 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. ## 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
•