Please suppose you have two dates (referred to the same day), expressed in the format:
Please help me to write the formula to represent the difference between DATE1 and DATE2, with the MINUS sign if DATE2 is earlier than DATE1.
DATE1 = 01:23:57
DATE2 = 03:46:59
DIFFERENCE = 02:23:02
DATE1 = 08:45:50
DATE2 = 08:43:50
DIFFERENCE = - 00:02:00
Please help me to write the BusinessObjects Client formula, too.