I have two fields in a row in the table. StartTimelcl and EndTimelcl, and I want to calculate the difference in minutes and seconds between the two fields. I have tried a few different approaches, none of which worked. Both times are date/time format; 1:52:01 PM and 1:54:37 PM, I would like the output tp be in mm:ss format. Using expression builder in query. Here is what i tried:
I also tried subtracting the start time from the end time. which didn't work. I get results that are way bigger than they should be.
Tried using format, but couldn't get it to work
Thanks
Code:
Duration: DateDiff("s",[PhoneCalltbl2]![StartTimeLc], [PhoneCalltbl2]![EndTimelLcl]/60
I also tried subtracting the start time from the end time. which didn't work. I get results that are way bigger than they should be.
Tried using format, but couldn't get it to work
Code:
Duration: Format(DateDiff([PhoneCalltbl2]![ETimeGMT],[PhoneCalltbl2]![StartTimeLc],"mm:ss"))
Thanks