Adding ifelse statement to the time difference formula

[former_member1010261]

Hi all,

I was able to calculate the time between order date and collection date (collection date - order date), but I realized that the collection date/time can come before the order date/time. In that case, I like to subtract the collection date/time from the order date/time.How can I go about doing this?

Formulas I used to calculate the time between order date and collection date:

TAT - Order to Collection (Sec)=DaysBetween([Ordered Date-Time];[Collection Date-Time])*86400 + ( ToNumber(FormatDate([Collection Date-Time];"HH"))*3600 + ToNumber(FormatDate([Collection Date-Time];"mm"))*60 + ToNumber(FormatDate([Collection Date-Time];"ss")) ) - ( ToNumber(FormatDate([Ordered Date-Time];"HH"))*3600 + ToNumber(FormatDate([Ordered Date-Time];"mm"))*60 + ToNumber(FormatDate([Ordered Date-Time];"ss")) )

TAT - Order to Collection=FormatNumber(Floor([TAT - Order to Collection (Sec)]/86400);"00") + " " + "Days" + " " + FormatNumber(Floor(Mod([TAT - Order to Collection (Sec)] ;86400)/3600);"00") + ":" + FormatNumber(Floor(Mod(Mod([TAT - Order to Collection (Sec)] ;86400);3600)/60);"00")

-----------------------------------------------------------------------------------------------

I was thinking about ifelse statement like this, but it doesn't work probably because I'm not formatting.

=If([Collection Date-Time]<[Ordered Date-Time]) Then [Ordered Date-Time] - [Collection Date-Time] Else [Collection Date-Time]-[Ordered Date-Time]

Thank you for your help!

[KatiNonhebel]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers(if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it:https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Kind regards,

Katarina (SAP Community Moderator)

[mhmohammed]

Hi Deborah,

Check out the below blogs.

https://answers.sap.com/questions/9283249/index.html

http://www.forumtopics.com/busobj/viewtopic.php?p=1021309

Thanks,
Mahboob Mohammed