Hi! I’m having trouble with DURATION! See below an example:
Column A [START DATE] Column B [START TIME] Column C [END DATE] Column D [END TIME] Column E [DURATION]: END TIME - START TIME.
However, when start and end DATES are different, the duration value doesn’t work because it calculate only based on hours. For example:
[START DATE]= 02/21/18 [START TIME]= 22:00 [END DATE]=22/02/18 [END TIME]= 01:00 [DURATION]= -21:00 (It should be 03:00 - from 22:00 day 02/22 to 01:00 day 02/22)
How can I solve that?
Thanks a lot!