Could anyone tell me how to find the difference of two time expression? I was trying to find subtract a time expression from another time expression, so that the resulting value is in minutes. Could anyone help me with this. The two time fields are as follows:
=Time(TIme#(Num(WORK_END_TIME,'0000'),'hhmm'),'hh:mm')
=Time(TIme#(Num(WORK_START_TIME,'0000'),'hhmm'),'hh:mm')
How do I get the time difference\ minutes from these time strings.
