Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need to subtract 15 minutes from a departure time

Hello all,

I need to subtract 15 minutes from a departure time. if my flight departs at 07:00 I need it to show a boarding time of 06:45. Below are the two formulas that I can use. I need to show both the departure time and boarding time on my form.

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

forumual 1 time field.

whileprintingrecords;
stringvar tm := "";
stringvar tntdept := "";


   tm := fos2time({TRIP_LEGS.ETD - local});

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

formula 2 date and time field.

whileprintingrecords;
stringvar dt := "";
stringvar tm := "";
stringvar tntdept := "";

if not isnull({TRIP_LEGS.Depart Date - Local}) and  {TRIP_LEGS.Depart Date - Local} <> 0 then
(
    dt := uppercase(totext(fos2date({TRIP_LEGS.Depart Date - Local}),"ddd   dd MMM yyyy"));
    tm := fos2time({TRIP_LEGS.ETD - local});
    if {TRIP_LEGS.ETD Tentative} = 1 then tntdept := " ?" else tntdept := "  ";
)
else
    "";



dt + space(4) + tm + tntdept;

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

Any help would be great.

Thanks

Bill

Former Member
Not what you were looking for? View more on this topic or Ask a question