Results 1 to 2 of 2

Thread: Understanding the formula...

  1. #1

    Understanding the formula...



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

    Hi,

    I have the following formula that helps me format time. All I need is to understand it a little more.

    =CEILING(IF(ISNUMBER(A2),A2,VALUE(LEFT(A2,LEN(A2)-3)&":00")+IF(AND(RIGHT(A2,2)="PM",LEFT(A2,2)<>"12"),0.5,0))-"00:45:00",--"01:00:00")

    Can someone help me with a 2-3 line explanation or more as you may deem fit.

    Thanks in advance!

    Jai

  2. #2
    Show us some examples of the data being processed, all types, the formula just looks like nonsense in isolation.

Posting Permissions

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