Hello,
kindly looking at the data below; i am trying to calculate how many hours/minutes/seconds it is from request time to close time. The calculation should be between 8am and 5pm, Monday to Friday only. Such that if the start time is 1/31/2016 19:59 and end time is 2/1/2016 10:01, it will only calculate from 2/1/2016 08:00 to 2/1/2016 10:01
could you kindly help me with this.
Request time Close time
1/31/2016 19:59 2/1/2016 10:01
1/31/2016 18:25 2/3/2016 16:58
1/30/2016 14:11 2/3/2016 8:22
1/30/2016 13:08 1/30/2016 15:19
1/30/2016 9:23 1/30/2016 9:29
1/29/2016 17:28 2/1/2016 13:42
1/29/2016 17:18 2/2/2016 18:08
1/29/2016 16:26 2/3/2016 11:59
1/29/2016 14:58 2/1/2016 8:12
1/29/2016 14:30 1/30/2016 12:18
1/29/2016 13:52 2/1/2016 12:25
1/29/2016 13:47 2/1/2016 8:01
1/29/2016 13:39 1/30/2016 11:16
1/29/2016 13:20 2/2/2016 8:25
1/29/2016 11:40 2/3/2016 7:50
1/29/2016 11:23 2/2/2016 8:26
1/29/2016 10:59 1/29/2016 13:06
1/29/2016 10:55 1/29/2016 14:17
1/29/2016 10:41 1/29/2016 13:38
1/29/2016 10:17 1/29/2016 15:58
1/29/2016 9:53 1/29/2016 11:01
1/29/2016 9:49 1/29/2016 15:32
1/29/2016 9:46 1/29/2016 12:54
1/29/2016 9:41 1/29/2016 10:03
1/29/2016 9:39 1/29/2016 10:56
1/29/2016 9:35 1/29/2016 10:09
1/29/2016 9:28 2/1/2016 8:14
1/29/2016 8:42 2/1/2016 11:40
1/29/2016 8:27 1/29/2016 9:13
1/29/2016 8:27 2/1/2016 14:39
1/29/2016 8:15 1/30/2016 8:46
i have seen lots of similar post but the formula's keep giving me negative values. i really don't no what i am doing wrong. please help me.