Thanks:  0
Likes:  0

# Thread: "If Formula" for elasped time

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

2. 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 ]

3. You did not state if cell contained
number or time.

with number
=INT(A48/20)*1

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

4. 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 ]

5. OK

revise to

numbers =INT(A48/20)

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

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