Too complex for me Time formula

**crazy_brit** · 01-31-2019, 08:18 AM

Hi All,

So i have a time column imported from a database which monitors users making changes to the database what I need is a formula that looks at the time in cell C2 compares it to cell C3 and if the time is greater than or equal to 15 mins return a value of 5mins. If however the value is less than 15 mins then compare cell C3 to C4 and so on until the value is greater than or equal to 15 mins at which point returning a value calculating the difference between the original starting cell and the final cell.

In a nutshell I am trying to calculate users time logged in to the database where I am giving them 5 mins for a single change and calculating time difference between their initial change and final change during a log in period.

Staff Name Date Time
user 1 23/01/2019 09:10
user 1 23/01/2019 12:20
user 1 23/01/2019 12:20
user 1 23/01/2019 12:21
user 1 23/01/2019 12:21
user 1 23/01/2019 12:21
user 1 23/01/2019 12:21
user 1 23/01/2019 12:25
user 1 23/01/2019 12:25
user 1 23/01/2019 12:25
user 1 23/01/2019 12:30
user 1 23/01/2019 12:30
user 1 23/01/2019 12:30
user 1 23/01/2019 12:30
user 1 23/01/2019 12:30
user 1 23/01/2019 12:30
user 1 23/01/2019 12:30
user 1 23/01/2019 12:30
user 1 23/01/2019 12:32
user 1 23/01/2019 12:33
user 1 23/01/2019 12:36
user 1 23/01/2019 12:36
user 1 23/01/2019 12:36
user 1 23/01/2019 12:36
user 1 23/01/2019 12:36
user 1 23/01/2019 12:37
user 1 23/01/2019 12:37
user 1 23/01/2019 12:37
user 1 23/01/2019 12:49
user 1 23/01/2019 12:49
user 1 23/01/2019 12:49
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:50
user 1 23/01/2019 12:51
user 1 23/01/2019 12:51
user 1 23/01/2019 12:51
user 1 23/01/2019 12:51
user 1 23/01/2019 12:51
user 1 23/01/2019 12:51
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:52
user 1 23/01/2019 12:54
user 1 23/01/2019 12:54
user 1 23/01/2019 12:54
user 1 23/01/2019 12:54
user 1 23/01/2019 12:54
user 1 23/01/2019 12:54
user 1 23/01/2019 12:54
user 1 23/01/2019 12:55
user 1 23/01/2019 12:55
user 1 23/01/2019 12:55
user 1 23/01/2019 12:55
user 1 23/01/2019 12:55
user 1 23/01/2019 12:55
user 1 23/01/2019 12:56
user 1 23/01/2019 12:56
user 1 23/01/2019 12:56
user 1 23/01/2019 12:56
user 1 23/01/2019 12:56
user 1 23/01/2019 12:56
user 1 23/01/2019 12:56
user 1 23/01/2019 12:56
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:57
user 1 23/01/2019 12:58
user 1 23/01/2019 12:58
user 1 23/01/2019 12:58
user 1 23/01/2019 12:58
user 1 23/01/2019 12:59
user 1 23/01/2019 12:59
user 1 23/01/2019 13:00
user 1 23/01/2019 13:00
user 1 23/01/2019 13:00
user 1 23/01/2019 13:00
user 1 23/01/2019 13:00
user 1 23/01/2019 13:00
user 1 23/01/2019 13:00
user 1 23/01/2019 13:01
user 1 23/01/2019 13:01
user 1 23/01/2019 13:01
user 1 23/01/2019 13:01
user 1 23/01/2019 13:01
user 1 23/01/2019 13:02
user 1 23/01/2019 13:02
user 1 23/01/2019 13:02
user 1 23/01/2019 13:02
user 1 23/01/2019 13:02
user 1 23/01/2019 13:02
user 1 23/01/2019 13:02
user 1 23/01/2019 13:04
user 1 23/01/2019 13:04
user 1 23/01/2019 13:04
user 1 23/01/2019 13:04
user 1 23/01/2019 13:04
user 1 23/01/2019 13:04
user 1 23/01/2019 13:04
user 1 23/01/2019 13:05
user 1 23/01/2019 13:05
user 1 23/01/2019 13:05
user 1 23/01/2019 13:05
user 1 23/01/2019 13:07
user 1 23/01/2019 13:07
user 1 23/01/2019 13:07
user 1 23/01/2019 13:07
user 1 23/01/2019 13:07
user 1 23/01/2019 13:08
user 1 23/01/2019 13:08
user 1 23/01/2019 13:08
user 1 23/01/2019 13:08
user 1 23/01/2019 13:08
user 1 23/01/2019 13:08
user 1 23/01/2019 13:09
user 1 23/01/2019 13:09
user 1 23/01/2019 13:09
user 1 23/01/2019 13:09
user 1 23/01/2019 13:09
user 1 23/01/2019 13:09
user 1 23/01/2019 13:09
user 1 23/01/2019 13:09
user 1 23/01/2019 13:12
user 1 23/01/2019 13:12
user 1 23/01/2019 13:13
user 1 23/01/2019 13:13
user 1 23/01/2019 13:13
user 1 23/01/2019 13:13
user 1 23/01/2019 13:13
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:14
user 1 23/01/2019 13:15
user 1 23/01/2019 13:15
user 1 23/01/2019 13:15
user 1 23/01/2019 13:15
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:16
user 1 23/01/2019 13:19
user 1 23/01/2019 13:19
user 1 23/01/2019 13:19
user 1 23/01/2019 13:19
user 1 23/01/2019 13:19
user 1 23/01/2019 13:19
user 1 23/01/2019 13:19
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:20
user 1 23/01/2019 13:27
user 1 23/01/2019 13:28
user 1 23/01/2019 13:28
user 1 23/01/2019 13:28
user 1 23/01/2019 13:28
user 1 23/01/2019 13:28
user 1 23/01/2019 13:29
user 1 23/01/2019 13:30
user 1 23/01/2019 13:30
user 1 23/01/2019 13:32
user 1 23/01/2019 13:32
user 1 23/01/2019 13:32
user 1 23/01/2019 13:32
user 1 23/01/2019 13:32
user 1 23/01/2019 13:34
user 1 23/01/2019 13:34
user 1 23/01/2019 13:34
user 1 23/01/2019 13:34
user 1 23/01/2019 13:34
user 1 23/01/2019 13:35
user 1 23/01/2019 13:35
user 1 23/01/2019 13:35
user 1 23/01/2019 13:36
user 1 23/01/2019 13:36
user 1 23/01/2019 13:36
user 1 23/01/2019 13:36
user 1 23/01/2019 13:36
user 1 23/01/2019 13:36
user 1 23/01/2019 13:36
user 1 23/01/2019 13:37
user 1 23/01/2019 13:37
user 1 23/01/2019 13:37
user 1 23/01/2019 13:37
user 1 23/01/2019 13:37
user 1 23/01/2019 13:37
user 1 23/01/2019 13:37
user 1 23/01/2019 13:38
user 1 23/01/2019 13:38
user 1 23/01/2019 13:38
user 1 23/01/2019 13:38
user 1 23/01/2019 13:54
user 1 23/01/2019 13:54
user 1 23/01/2019 13:54
user 1 23/01/2019 13:54
user 1 23/01/2019 13:54
user 1 23/01/2019 13:54
user 1 23/01/2019 13:54
user 1 23/01/2019 13:54
user 1 23/01/2019 13:59
user 1 23/01/2019 13:59
user 1 23/01/2019 13:59
user 1 23/01/2019 13:59
user 1 23/01/2019 14:00
user 1 23/01/2019 14:00
user 1 23/01/2019 14:00
user 1 23/01/2019 14:00
user 1 23/01/2019 14:01
user 1 23/01/2019 14:01
user 1 23/01/2019 14:01
user 1 23/01/2019 14:01
user 1 23/01/2019 14:01
user 1 23/01/2019 14:01
user 1 23/01/2019 14:02
user 1 23/01/2019 14:07
user 1 23/01/2019 14:07
user 1 23/01/2019 14:08
user 1 23/01/2019 14:08
user 1 23/01/2019 14:09
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:10
user 1 23/01/2019 14:11
user 1 23/01/2019 14:11
user 1 23/01/2019 14:11
user 1 23/01/2019 14:12
user 1 23/01/2019 14:12
user 1 23/01/2019 14:13
user 1 23/01/2019 14:13
user 1 23/01/2019 14:13
user 1 23/01/2019 14:13
user 1 23/01/2019 14:13
user 1 23/01/2019 14:13
user 1 23/01/2019 14:16
user 1 23/01/2019 14:16
user 1 23/01/2019 14:16
user 1 23/01/2019 14:16
user 1 23/01/2019 14:16
user 1 23/01/2019 14:16
user 1 23/01/2019 14:17
user 1 23/01/2019 14:17
user 1 23/01/2019 14:17
user 1 23/01/2019 14:17
user 1 23/01/2019 14:17
user 1 23/01/2019 14:18
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:19
user 1 23/01/2019 14:20
user 1 23/01/2019 14:20
user 1 23/01/2019 14:20
user 1 23/01/2019 14:20
user 1 23/01/2019 14:20
user 1 23/01/2019 14:20
user 1 23/01/2019 14:20
user 1 23/01/2019 14:20
user 1 23/01/2019 14:21
user 1 23/01/2019 14:26
user 1 23/01/2019 14:27
user 1 23/01/2019 14:27
user 1 23/01/2019 14:27
user 1 23/01/2019 14:27
user 1 23/01/2019 14:27
user 1 23/01/2019 14:27
user 1 23/01/2019 14:27
user 1 23/01/2019 14:59
user 1 23/01/2019 14:59
user 1 23/01/2019 14:59
user 1 23/01/2019 15:00
user 1 23/01/2019 15:00
user 1 23/01/2019 15:01
user 1 23/01/2019 15:01
user 1 23/01/2019 15:01
user 1 23/01/2019 15:01
user 1 23/01/2019 15:01
user 1 23/01/2019 15:01
user 1 23/01/2019 15:02
user 1 23/01/2019 15:02
user 1 23/01/2019 15:02
user 1 23/01/2019 15:03
user 1 23/01/2019 15:03
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:04
user 1 23/01/2019 15:05
user 1 23/01/2019 15:05
user 1 23/01/2019 15:05
user 1 23/01/2019 15:05
user 1 23/01/2019 15:06
user 1 23/01/2019 15:06
user 1 23/01/2019 15:06
user 1 23/01/2019 15:07
user 1 23/01/2019 15:07
user 1 23/01/2019 15:07
user 1 23/01/2019 15:07
user 1 23/01/2019 15:07
user 1 23/01/2019 15:07
user 1 23/01/2019 15:07
user 1 23/01/2019 15:08
user 1 23/01/2019 15:08
user 1 23/01/2019 15:08
user 1 23/01/2019 15:08
user 1 23/01/2019 15:08
user 1 23/01/2019 15:08
user 1 23/01/2019 15:08
user 1 23/01/2019 15:09
user 1 23/01/2019 15:09
user 1 23/01/2019 15:09
user 1 23/01/2019 15:09
user 1 23/01/2019 15:09
user 1 23/01/2019 15:09
user 1 23/01/2019 15:09
user 1 23/01/2019 15:09
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:10
user 1 23/01/2019 15:11
user 1 23/01/2019 15:11
user 1 23/01/2019 15:11
user 1 24/01/2019 09:03
user 1 24/01/2019 09:03
user 1 24/01/2019 09:03
user 1 24/01/2019 09:03
user 1 24/01/2019 09:03
user 1 24/01/2019 09:04
user 1 24/01/2019 09:06
user 1 24/01/2019 09:06
user 1 24/01/2019 09:06
user 1 24/01/2019 09:20
user 1 24/01/2019 09:24
user 1 24/01/2019 09:24
user 1 24/01/2019 09:26
user 1 24/01/2019 09:26
user 1 24/01/2019 09:26
user 1 24/01/2019 09:26
user 1 24/01/2019 09:26
user 1 24/01/2019 09:26
user 1 24/01/2019 09:26
user 1 24/01/2019 09:28
user 1 24/01/2019 09:28
user 1 24/01/2019 09:28
user 1 24/01/2019 09:28
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:29
user 1 24/01/2019 09:30
user 1 24/01/2019 09:30
user 1 24/01/2019 09:30
user 1 24/01/2019 09:30
user 1 24/01/2019 09:30
user 1 24/01/2019 09:30
user 1 24/01/2019 09:30
user 1 24/01/2019 09:31
user 1 24/01/2019 09:31
user 1 24/01/2019 09:33
user 1 24/01/2019 09:34
user 1 24/01/2019 09:34
user 1 24/01/2019 09:35
user 1 24/01/2019 09:36
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:38
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:39
user 1 24/01/2019 09:40
user 1 24/01/2019 09:40
user 1 24/01/2019 10:19
user 1 24/01/2019 10:19
user 1 24/01/2019 10:19
user 1 24/01/2019 10:19
user 1 24/01/2019 10:19
user 1 24/01/2019 10:20
user 1 24/01/2019 10:43
user 1 24/01/2019 10:43
user 1 24/01/2019 10:43
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:44
user 1 24/01/2019 10:45
user 1 24/01/2019 10:45
user 1 24/01/2019 10:45
user 1 24/01/2019 10:55

**crazy_brit** · 01-31-2019, 08:21 AM

Sorry I meant to say thankyou for any help in anticipation
Kind Regards
Lee

**PaulM100** · 01-31-2019, 08:28 AM

This should do it:
=IFERROR(IF((c2-c1)*24*60>=15,5,""),"")

**KOKOSEK** · 01-31-2019, 08:50 AM

Try into D2:

Formula:

Please Login or Register  to view this content.

Sorry, Ive forgot to mention that I've removed duplicates as first

**davsth** · 01-31-2019, 08:56 AM

I think you need to attach a small sample with the expected results. I also think that if times span midnight the logic of 5 minutes wont work on column C as you need to look at a value containing a date and time

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**crazy_brit** · 01-31-2019, 10:47 AM

Hi, thanks for responses, I tried to attach a file but having trouble this is what I expect the output to be like yes I agree I may need to link Date and time together for users going through midnight, also it needs to monitor for user name changes, I am trying to automate logged in time for users as time sheets they are submitting doesn't tally with what I see in the application log, this is well beyond my capabilities thanks again
Lee

Name Date Time
user 1 23/01/2019 09:10 5 5 mins allocated because it’s a single change with 15 mins gap before and after
user 1 23/01/2019 12:20
user 1 23/01/2019 12:21
user 1 23/01/2019 12:25
user 1 23/01/2019 12:30
user 1 23/01/2019 12:32
user 1 23/01/2019 12:33
user 1 23/01/2019 12:36
user 1 23/01/2019 12:37
user 1 23/01/2019 12:49
user 1 23/01/2019 12:50
user 1 23/01/2019 12:51
user 1 23/01/2019 12:52
user 1 23/01/2019 12:54
user 1 23/01/2019 12:55
user 1 23/01/2019 12:56
user 1 23/01/2019 12:57
user 1 23/01/2019 12:58
user 1 23/01/2019 12:59
user 1 23/01/2019 13:00
user 1 23/01/2019 13:01
user 1 23/01/2019 13:02
user 1 23/01/2019 13:04
user 1 23/01/2019 13:05
user 1 23/01/2019 13:07
user 1 23/01/2019 13:08
user 1 23/01/2019 13:09
user 1 23/01/2019 13:12
user 1 23/01/2019 13:13
user 1 23/01/2019 13:14
user 1 23/01/2019 13:15
user 1 23/01/2019 13:16
user 1 23/01/2019 13:19
user 1 23/01/2019 13:20
user 1 23/01/2019 13:27
user 1 23/01/2019 13:28
user 1 23/01/2019 13:29
user 1 23/01/2019 13:30
user 1 23/01/2019 13:32
user 1 23/01/2019 13:34
user 1 23/01/2019 13:35
user 1 23/01/2019 13:36
user 1 23/01/2019 13:37
user 1 23/01/2019 13:38 78 78 mins between 12:20 and 13:38 because the next cell has over a 15 min gap
user 1 23/01/2019 13:54
user 1 23/01/2019 13:59
user 1 23/01/2019 14:00
user 1 23/01/2019 14:01
user 1 23/01/2019 14:02
user 1 23/01/2019 14:07
user 1 23/01/2019 14:08
user 1 23/01/2019 14:09
user 1 23/01/2019 14:10
user 1 23/01/2019 14:11
user 1 23/01/2019 14:12
user 1 23/01/2019 14:13
user 1 23/01/2019 14:16
user 1 23/01/2019 14:17
user 1 23/01/2019 14:18
user 1 23/01/2019 14:19
user 1 23/01/2019 14:20
user 1 23/01/2019 14:21
user 1 23/01/2019 14:26
user 1 23/01/2019 14:27 33 33 mins between 13:54 and 14:27 following cell has over 15 min gap
user 1 23/01/2019 14:59

**JeteMc** · 02-05-2019, 11:50 PM

Hello crazy_brit and Welcome to Excel Forum.
As to attaching a file click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window. (The paperclip icon doesn't work.)
Let us know if you have any questions/problems.

**JeteMc** · 02-06-2019, 12:40 AM

Here is a modification to KOKOSEK's formula that yields the same values as those displayed in post #6:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

**crazy_brit** · 02-06-2019, 11:00 AM

Hi JeteMc,
I Have used this Formula then created a pivot table summing the new coloumn, as it incorporates the over midnight problem, its probably far more complex than it need to be your thoughts are welcome

Kindest Regards Lee

Formula:

Please Login or Register  to view this content.

**JeteMc** · 02-09-2019, 12:11 PM

If it isn't too complex for you to understand, and if it works, then it is fine. Only thing I might ask is, is there a chance that down the road you would want to change the 5 min allocation to 4 or 6 (or some other value)? If so you may consider putting the 0.0034722222 in a cell and referencing that cell in the formula. That way you will not have to change the formula if/when the allocation changes.
If your issue is resolved, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

Too complex for me Time formula

LinkBack

Thread Tools

Rate This Thread

Display

Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Re: Too complex for me Time formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Complex Offset Formula and Return Values - Time between parts

[SOLVED] Complex formula getting moer complex

Simplify this complex formula I've come up with for sorting mixed format time.

[SOLVED] Complex Time Calculation

[SOLVED] Complex convert time to minutes formula required

Complex array formula takes long time to return results

Time Date and Graph help (complex formula)

Bookmarks

Bookmarks

Posting Permissions