SUBTOTAL function does not produce correct results when using time

[Peter Espinoza]

I am still having issues with this. Trying to use subtotal time based on event day by driver. gives me 0 subtotals. Even sum function will not work. Only way to work is to manually enter. (=D2+D3+....)

EventDay2 Driver Evt_Comment Time
Date: Sun 09/04/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:26:12) 0:26:12
Date: Sun 09/04/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:36:09) 0:36:09
Date: Sun 09/04/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:47:58) 0:47:58
Date: Sun 09/04/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(1:04:05) 1:04:05
Date: Sun 09/04/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:35:23) 0:35:23
Date: Sun 09/04/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(1:11:36) 1:11:36
Date: Sun 09/04/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:59:18) 0:59:18
Date: Mon 09/05/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:22:11) 0:22:11
Date: Mon 09/05/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:02:13) 0:02:13
Date: Mon 09/05/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:41:54) 0:41:54
Date: Mon 09/05/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:29:19) 0:29:19
Date: Mon 09/05/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:49:11) 0:49:11
Date: Mon 09/05/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:20:10) 0:20:10
Date: Tue 09/06/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:23:55) 0:23:55
Date: Tue 09/06/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:05:04) 0:05:04
Date: Tue 09/06/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(1:06:42) 1:06:42
Date: Tue 09/06/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(1:03:56) 1:03:56
Date: Tue 09/06/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(1:17:51) 1:17:51
Date: Wed 09/07/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:50:37) 0:50:37
Date: Wed 09/07/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:56:08) 0:56:08
Date: Wed 09/07/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(1:10:48) 1:10:48
Date: Wed 09/07/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:00:13) 0:00:13
Date: Wed 09/07/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:51:23) 0:51:23
Date: Wed 09/07/2016 Driver Name / ID: ANDRES FLORES / 364182 On Duty(0:28:15) 0:28:15

 

[NARAYANK991]

Hi ,

The easiest way to ensure you get a quick response from the forum , is to upload a workbook with data in it.

If you post the data in your thread , you are forcing members who wish to help to copy the data , paste it into a workbook , do a Text to Columns in order to separate the data appropriately , and then go about creating a formula to solve your problem.

Uploading a workbook ensures that members can spend more time thinking of how to solve the problem rather than getting the posted data into a workbook.

Narayan