Using Time in IF functions

[Guest]

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)

Please help! This is bothering me!

 

[Aladin Akyurek]

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)

Please help! This is bothering me!

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

 

[RichardS]

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