Elasped Time

[Parra]

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.

[Mark W.]

=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 ]

[Parra]

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.

[Mark W.]

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 ]