Results 1 to 2 of 2

Thread: calculate with number and time

  1. #1
    Seeker krishak77's Avatar
    Join Date
    Jun 2021
    Posts
    6
    Articles
    0
    Excel Version
    2008

    calculate with number and time



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello All,


    I need formula for the below criteria

    If on the A column having greater than 0 and on B column lesser than 5.30pm, then on C column it should map as Past
    If on the A column having Equals to 1 and on B column Greater than 5.30pm, then on C column it should map as Present
    If on the A column having Equals to 0 and on B column lesser than 5.30pm, then on C column it should map as Present
    If on the A column having Equals to 0 and on B column Greater than 5.30pm, then on C column it should map as Future.

    Below are the few examples which i need like below.

    Number Time Status
    1 4.30pm Past
    1 5.30pm Past
    1 6.30pm Present
    0 5.30pm Present
    0 5.40pm Future

    Thank you in advance.

    Regards,
    Anantha

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,701
    Articles
    0
    Excel Version
    Office 365 Subscription
    Please attach a sample workbook.

    Do you have MS365? There is no Excel 2008, so I think that's just the release number).
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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