Thanks:  0
Likes:  0

1. I have a formula that calculates how much time has passed.

a1 = 1:00 pm
a2 = 1:37 pm
a3 = 0:37

What I want in a4, is a formula that divides a3 by 20 and rounds up.

for example

a4 = 2

Thank you for helping me.

2. =ROUND(A3*72,0)

Note...

72 = 1440 (minutes/day) divided by 20

Is this related to your request at http://www.mrexcel.com/board/viewtop...c=2965&forum=2?

[ This Message was edited by: Mark W. on 2002-03-21 15:52 ]

3. Thanks it worked. I just had to change the cell format to get it to work. Thank you

Yes, it was related to the previous question but I did not know if I worded it properly.

4. On 2002-03-21 16:19, Parra wrote:
I just had to change the cell format to get it to work
Yeah, I should have mentioned that! If you enter a formula with a reference to a cell that's formatted as a time value Excel applies the same format to the cell containing the formula. Sometimes it can be quite annoying.

[ This Message was edited by: Mark W. on 2002-03-21 16:42 ]

## User Tag List

#### Posting Permissions

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