Using Time in IF functions
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Using Time in IF functions

  1. #1
    Guest

    Default

     
    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!

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,778
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    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)

  3. #3
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com