Thanks:  0
Likes:  0

# Thread: Using Time in IF functions

1. I am making a spreadsheet for calculating long distance usage. I would like a formula to calculate the charge based on the time of the call and the duration. For example, a 15 minute call would be more expensive before 5pm. I would you would use an IF formula but I don't know how to format the time.

=IF(A1<(i want this to be 5pm),B1*.09,B1*.07)

2. On 2002-03-04 13:33, Anonymous wrote:
I am making a spreadsheet for calculating long distance usage. I would like a formula to calculate the charge based on the time of the call and the duration. For example, a 15 minute call would be more expensive before 5pm. I would you would use an IF formula but I don't know how to format the time.

=IF(A1<(i want this to be 5pm),B1*.09,B1*.07)

=IF(A1<"17:00"+0,B1*.09,B1*.07)

3. Try putting 5:00 PM in another cell, and replace your (I want the time here bit) with the cell reference.
HTH
Richard

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