"If Formula" for elasped time

[Parra]

I want to do an if formula for elasped time. If 20 minutes have passed I want "1" to appear 40 minutes "2", 60 minutes "3" and so on.

I have the elasped time thing done. But I can't seem to get the if function to work, can someone please help. Thanks.

[Mark W.]

Use =TRUNC(A1/20) where A1 contains your elapsed time as minutes. If A1 contains a time value (e.g., 0:20) use =TRUNC(A1*72). An IF function isn't necessary.

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

[Dave Patton]

You did not state if cell contained
number or time.

with number
=INT(A48/20)*1

with time
=INT(MINUTE(A50)/20)*1

[Mark W.]

with time
=INT(MINUTE(A50)/20)*1

What if the elapsed time value is 1:40 (1 hour and 40 minutes)? Or 60 minutes which Excel will represent as 1:00?

What does the "*1" do?

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

[Dave Patton]

OK

revise to

numbers =INT(A48/20)

times =INT(MINUTE(A50)+HOUR(A50)*60)/20