Using date to pull data

F

FuelGuy

New Member
Joined
May 31, 2023
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
Have data which is pulled every 15 minutes (or so) 24 hours a day.
Need to isolate data by day and determine gallons of product used per day.
Currently have 3 months of data.
1685565055223.png
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
so, do you want a formula that lists totals gallons per day?
 
Upvote 0
TRY:
Mr excel questions 39.xlsm
ABCD
1timestamp(CDT)Bulk Tank
22023-05-25 00:003,543.6842023-05-25369,712.037
32023-05-25 00:154,893.4182023-05-26363,392.163
42023-05-25 00:303,333.0332023-05-27370,770.561
52023-05-25 00:452,533.3652023-05-28233,097.688
62023-05-25 01:002,629.453
72023-05-25 01:154,350.905
82023-05-25 01:304,509.426
92023-05-25 01:454,921.835
102023-05-25 02:003,951.869
112023-05-25 02:152,955.933
122023-05-25 02:303,556.592
132023-05-25 02:452,724.197
142023-05-25 03:004,675.121
152023-05-25 03:154,960.911
162023-05-25 03:302,609.553
172023-05-25 03:453,979.518
182023-05-25 04:002,617.946
192023-05-25 04:154,065.461
202023-05-25 04:304,367.874
212023-05-25 04:454,869.658
222023-05-25 05:004,626.680
232023-05-25 05:153,949.372
242023-05-25 05:303,801.736
252023-05-25 05:454,951.604
262023-05-25 06:004,148.688
272023-05-25 06:152,656.062
282023-05-25 06:303,695.410
292023-05-25 06:453,989.715
302023-05-25 07:002,745.707
312023-05-25 07:153,994.317
322023-05-25 07:304,176.630
332023-05-25 07:454,248.454
342023-05-25 08:002,678.433
352023-05-25 08:154,174.890
362023-05-25 08:304,935.301
372023-05-25 08:454,539.801
382023-05-25 09:003,949.855
392023-05-25 09:152,900.042
402023-05-25 09:303,270.960
412023-05-25 09:454,357.751
422023-05-25 10:004,705.759
432023-05-25 10:154,450.019
442023-05-25 10:304,296.972
452023-05-25 10:454,355.261
462023-05-25 11:004,536.933
472023-05-25 11:153,102.177
482023-05-25 11:303,048.015
492023-05-25 11:453,818.781
502023-05-25 12:002,574.317
512023-05-25 12:152,838.419
522023-05-25 12:303,746.814
532023-05-25 12:453,271.120
542023-05-25 13:004,927.723
552023-05-25 13:154,413.971
562023-05-25 13:304,923.701
572023-05-25 13:452,979.913
582023-05-25 14:004,278.016
592023-05-25 14:154,984.930
602023-05-25 14:303,830.401
612023-05-25 14:453,397.071
622023-05-25 15:004,242.609
632023-05-25 15:153,669.633
642023-05-25 15:304,699.492
652023-05-25 15:454,082.318
662023-05-25 16:003,111.400
672023-05-25 16:154,190.465
682023-05-25 16:304,452.069
692023-05-25 16:454,459.071
702023-05-25 17:003,740.578
712023-05-25 17:154,988.494
722023-05-25 17:302,874.251
732023-05-25 17:453,407.785
742023-05-25 18:003,909.316
752023-05-25 18:153,943.639
762023-05-25 18:304,508.493
772023-05-25 18:454,429.107
782023-05-25 19:003,203.962
792023-05-25 19:154,092.113
802023-05-25 19:302,744.391
812023-05-25 19:454,689.514
822023-05-25 20:004,833.582
832023-05-25 20:153,123.539
842023-05-25 20:302,539.090
852023-05-25 20:453,347.668
862023-05-25 21:003,973.561
872023-05-25 21:154,961.064
882023-05-25 21:303,248.690
892023-05-25 21:454,026.942
902023-05-25 22:003,367.006
912023-05-25 22:154,584.429
922023-05-25 22:303,371.675
932023-05-25 22:453,500.595
942023-05-25 23:003,578.683
952023-05-25 23:152,517.467
962023-05-25 23:304,062.375
972023-05-25 23:452,915.498
982023-05-26 00:004,854.241
992023-05-26 00:153,374.123
1002023-05-26 00:304,202.271
1012023-05-26 00:453,801.963
1022023-05-26 01:003,879.035
1032023-05-26 01:154,299.921
1042023-05-26 01:303,615.864
1052023-05-26 01:453,510.851
1062023-05-26 02:003,736.593
1072023-05-26 02:154,055.021
1082023-05-26 02:302,786.757
1092023-05-26 02:452,505.937
1102023-05-26 03:003,293.731
1112023-05-26 03:153,164.893
1122023-05-26 03:304,638.357
1132023-05-26 03:453,140.272
1142023-05-26 04:003,613.675
1152023-05-26 04:154,805.370
1162023-05-26 04:304,007.973
1172023-05-26 04:454,799.437
1182023-05-26 05:003,540.563
1192023-05-26 05:152,796.180
1202023-05-26 05:303,409.344
1212023-05-26 05:454,932.527
1222023-05-26 06:002,621.287
1232023-05-26 06:153,083.597
1242023-05-26 06:303,135.494
1252023-05-26 06:453,749.298
1262023-05-26 07:003,617.735
1272023-05-26 07:154,842.609
1282023-05-26 07:302,675.325
1292023-05-26 07:453,597.158
1302023-05-26 08:002,540.299
1312023-05-26 08:154,957.967
1322023-05-26 08:304,076.378
1332023-05-26 08:454,851.608
1342023-05-26 09:004,246.061
1352023-05-26 09:153,144.135
1362023-05-26 09:303,667.679
1372023-05-26 09:454,875.599
1382023-05-26 10:004,687.647
1392023-05-26 10:152,923.376
1402023-05-26 10:304,818.846
1412023-05-26 10:453,585.311
1422023-05-26 11:003,801.031
1432023-05-26 11:152,927.190
1442023-05-26 11:302,541.055
1452023-05-26 11:454,970.960
1462023-05-26 12:003,253.313
1472023-05-26 12:154,844.542
1482023-05-26 12:302,571.619
1492023-05-26 12:454,052.134
1502023-05-26 13:003,356.909
1512023-05-26 13:153,139.740
1522023-05-26 13:303,516.037
1532023-05-26 13:454,284.775
1542023-05-26 14:004,923.858
1552023-05-26 14:152,959.095
1562023-05-26 14:302,760.923
1572023-05-26 14:453,159.566
1582023-05-26 15:003,829.724
1592023-05-26 15:152,563.510
1602023-05-26 15:303,253.971
1612023-05-26 15:454,322.738
1622023-05-26 16:004,764.061
1632023-05-26 16:153,890.872
1642023-05-26 16:302,754.680
1652023-05-26 16:452,899.037
1662023-05-26 17:003,113.563
1672023-05-26 17:152,970.902
1682023-05-26 17:304,951.536
1692023-05-26 17:454,596.098
1702023-05-26 18:004,878.535
1712023-05-26 18:153,929.126
1722023-05-26 18:303,582.341
1732023-05-26 18:454,207.872
1742023-05-26 19:003,496.071
1752023-05-26 19:154,934.956
1762023-05-26 19:304,733.501
1772023-05-26 19:454,654.295
1782023-05-26 20:004,760.982
1792023-05-26 20:153,293.795
1802023-05-26 20:303,872.873
1812023-05-26 20:454,414.687
1822023-05-26 21:004,107.595
1832023-05-26 21:152,859.311
1842023-05-26 21:304,622.270
1852023-05-26 21:454,419.287
1862023-05-26 22:003,691.419
1872023-05-26 22:153,078.195
1882023-05-26 22:304,651.941
1892023-05-26 22:453,988.712
1902023-05-26 23:002,813.172
1912023-05-26 23:153,856.650
1922023-05-26 23:304,300.160
1932023-05-26 23:452,808.670
1942023-05-27 00:002,853.819
1952023-05-27 00:154,085.773
1962023-05-27 00:303,124.999
1972023-05-27 00:454,357.455
1982023-05-27 01:003,580.518
1992023-05-27 01:154,176.435
2002023-05-27 01:303,663.732
2012023-05-27 01:454,269.002
2022023-05-27 02:004,307.188
2032023-05-27 02:153,424.705
2042023-05-27 02:302,810.704
2052023-05-27 02:454,483.003
2062023-05-27 03:004,464.391
2072023-05-27 03:154,936.221
2082023-05-27 03:303,931.213
2092023-05-27 03:453,135.548
2102023-05-27 04:004,887.896
2112023-05-27 04:154,707.776
2122023-05-27 04:303,255.956
2132023-05-27 04:453,383.180
2142023-05-27 05:004,542.526
2152023-05-27 05:152,998.649
2162023-05-27 05:304,896.142
2172023-05-27 05:454,841.498
2182023-05-27 06:004,036.712
2192023-05-27 06:154,124.787
2202023-05-27 06:304,283.040
2212023-05-27 06:454,582.141
2222023-05-27 07:003,633.025
2232023-05-27 07:153,351.614
2242023-05-27 07:302,515.021
2252023-05-27 07:453,917.319
2262023-05-27 08:004,888.188
2272023-05-27 08:154,996.003
2282023-05-27 08:302,572.069
2292023-05-27 08:453,686.220
2302023-05-27 09:003,391.679
2312023-05-27 09:153,957.418
2322023-05-27 09:303,375.660
2332023-05-27 09:454,614.300
2342023-05-27 10:002,755.170
2352023-05-27 10:154,609.192
2362023-05-27 10:304,975.713
2372023-05-27 10:453,937.816
2382023-05-27 11:004,180.184
2392023-05-27 11:153,395.402
2402023-05-27 11:302,568.701
2412023-05-27 11:454,956.661
2422023-05-27 12:004,572.909
2432023-05-27 12:154,870.264
2442023-05-27 12:304,749.312
2452023-05-27 12:454,700.538
2462023-05-27 13:004,960.593
2472023-05-27 13:153,166.258
2482023-05-27 13:304,278.986
2492023-05-27 13:454,936.318
2502023-05-27 14:004,143.954
2512023-05-27 14:152,555.252
2522023-05-27 14:304,690.834
2532023-05-27 14:453,637.657
2542023-05-27 15:003,513.479
2552023-05-27 15:153,349.227
2562023-05-27 15:303,975.166
2572023-05-27 15:454,506.404
2582023-05-27 16:002,523.085
2592023-05-27 16:153,441.484
2602023-05-27 16:304,776.012
2612023-05-27 16:453,459.081
2622023-05-27 17:004,836.390
2632023-05-27 17:152,752.382
2642023-05-27 17:303,342.067
2652023-05-27 17:454,749.390
2662023-05-27 18:003,946.333
2672023-05-27 18:152,946.789
2682023-05-27 18:304,442.373
2692023-05-27 18:454,145.994
2702023-05-27 19:003,340.135
2712023-05-27 19:152,565.145
2722023-05-27 19:302,834.078
2732023-05-27 19:452,554.646
2742023-05-27 20:002,732.058
2752023-05-27 20:154,689.157
2762023-05-27 20:304,906.193
2772023-05-27 20:454,419.924
2782023-05-27 21:004,181.468
2792023-05-27 21:152,837.234
2802023-05-27 21:304,775.140
2812023-05-27 21:452,769.375
2822023-05-27 22:002,789.085
2832023-05-27 22:154,977.658
2842023-05-27 22:302,881.141
2852023-05-27 22:452,912.858
2862023-05-27 23:003,491.305
2872023-05-27 23:153,143.691
2882023-05-27 23:303,084.180
2892023-05-27 23:454,495.195
2902023-05-28 00:003,809.750
2912023-05-28 00:153,758.614
2922023-05-28 00:303,798.959
2932023-05-28 00:454,940.421
2942023-05-28 01:002,919.216
2952023-05-28 01:154,123.632
2962023-05-28 01:303,857.419
2972023-05-28 01:453,160.531
2982023-05-28 02:004,870.645
2992023-05-28 02:152,658.773
3002023-05-28 02:303,707.175
3012023-05-28 02:453,938.097
3022023-05-28 03:004,848.035
3032023-05-28 03:153,040.145
3042023-05-28 03:304,988.218
3052023-05-28 03:454,687.774
3062023-05-28 04:004,854.480
3072023-05-28 04:154,698.772
3082023-05-28 04:303,334.346
3092023-05-28 04:454,269.153
3102023-05-28 05:004,685.021
3112023-05-28 05:154,339.982
3122023-05-28 05:302,816.996
3132023-05-28 05:452,892.156
3142023-05-28 06:002,506.396
3152023-05-28 06:153,074.940
3162023-05-28 06:303,596.034
3172023-05-28 06:453,974.216
3182023-05-28 07:003,159.727
3192023-05-28 07:152,907.092
3202023-05-28 07:304,718.050
3212023-05-28 07:453,079.479
3222023-05-28 08:004,589.698
3232023-05-28 08:154,529.480
3242023-05-28 08:303,109.199
3252023-05-28 08:454,735.634
3262023-05-28 09:002,697.443
3272023-05-28 09:153,180.370
3282023-05-28 09:303,820.325
3292023-05-28 09:454,259.579
3302023-05-28 10:002,830.298
3312023-05-28 10:154,077.685
3322023-05-28 10:302,593.408
3332023-05-28 10:453,439.681
3342023-05-28 11:004,155.010
3352023-05-28 11:153,323.551
3362023-05-28 11:304,350.591
3372023-05-28 11:453,395.538
3382023-05-28 12:004,488.074
3392023-05-28 12:152,502.892
3402023-05-28 12:303,418.300
3412023-05-28 12:454,042.614
3422023-05-28 13:004,738.530
3432023-05-28 13:154,865.609
3442023-05-28 13:303,264.728
3452023-05-28 13:453,492.816
3462023-05-28 14:003,195.093
3472023-05-28 14:154,717.353
3482023-05-28 14:302,980.781
3492023-05-28 14:452,592.815
3502023-05-28 15:004,507.734
3512023-05-28 15:153,188.615
fuelguy
Cell Formulas
RangeFormula
D2:D5D2=SUMIFS(B2:B351,A2:A351,">="&C2,A2:A351,"<"&C2+1)
 
Upvote 0
awoohaw said:
so, do you want a formula that lists totals gallons per day?
Click to expand...
More interested in how to select each date (ex. 5/31/2023) and subtract the last reading of the day from the first reading of the day.
 
Upvote 0
awoohaw said:
TRY:
Mr excel questions 39.xlsm
ABCD
1timestamp(CDT)Bulk Tank
22023-05-25 00:003,543.6842023-05-25369,712.037
32023-05-25 00:154,893.4182023-05-26363,392.163
42023-05-25 00:303,333.0332023-05-27370,770.561
52023-05-25 00:452,533.3652023-05-28233,097.688
62023-05-25 01:002,629.453
72023-05-25 01:154,350.905
82023-05-25 01:304,509.426
92023-05-25 01:454,921.835
102023-05-25 02:003,951.869
112023-05-25 02:152,955.933
122023-05-25 02:303,556.592
132023-05-25 02:452,724.197
142023-05-25 03:004,675.121
152023-05-25 03:154,960.911
162023-05-25 03:302,609.553
172023-05-25 03:453,979.518
182023-05-25 04:002,617.946
192023-05-25 04:154,065.461
202023-05-25 04:304,367.874
212023-05-25 04:454,869.658
222023-05-25 05:004,626.680
232023-05-25 05:153,949.372
242023-05-25 05:303,801.736
252023-05-25 05:454,951.604
262023-05-25 06:004,148.688
272023-05-25 06:152,656.062
282023-05-25 06:303,695.410
292023-05-25 06:453,989.715
302023-05-25 07:002,745.707
312023-05-25 07:153,994.317
322023-05-25 07:304,176.630
332023-05-25 07:454,248.454
342023-05-25 08:002,678.433
352023-05-25 08:154,174.890
362023-05-25 08:304,935.301
372023-05-25 08:454,539.801
382023-05-25 09:003,949.855
392023-05-25 09:152,900.042
402023-05-25 09:303,270.960
412023-05-25 09:454,357.751
422023-05-25 10:004,705.759
432023-05-25 10:154,450.019
442023-05-25 10:304,296.972
452023-05-25 10:454,355.261
462023-05-25 11:004,536.933
472023-05-25 11:153,102.177
482023-05-25 11:303,048.015
492023-05-25 11:453,818.781
502023-05-25 12:002,574.317
512023-05-25 12:152,838.419
522023-05-25 12:303,746.814
532023-05-25 12:453,271.120
542023-05-25 13:004,927.723
552023-05-25 13:154,413.971
562023-05-25 13:304,923.701
572023-05-25 13:452,979.913
582023-05-25 14:004,278.016
592023-05-25 14:154,984.930
602023-05-25 14:303,830.401
612023-05-25 14:453,397.071
622023-05-25 15:004,242.609
632023-05-25 15:153,669.633
642023-05-25 15:304,699.492
652023-05-25 15:454,082.318
662023-05-25 16:003,111.400
672023-05-25 16:154,190.465
682023-05-25 16:304,452.069
692023-05-25 16:454,459.071
702023-05-25 17:003,740.578
712023-05-25 17:154,988.494
722023-05-25 17:302,874.251
732023-05-25 17:453,407.785
742023-05-25 18:003,909.316
752023-05-25 18:153,943.639
762023-05-25 18:304,508.493
772023-05-25 18:454,429.107
782023-05-25 19:003,203.962
792023-05-25 19:154,092.113
802023-05-25 19:302,744.391
812023-05-25 19:454,689.514
822023-05-25 20:004,833.582
832023-05-25 20:153,123.539
842023-05-25 20:302,539.090
852023-05-25 20:453,347.668
862023-05-25 21:003,973.561
872023-05-25 21:154,961.064
882023-05-25 21:303,248.690
892023-05-25 21:454,026.942
902023-05-25 22:003,367.006
912023-05-25 22:154,584.429
922023-05-25 22:303,371.675
932023-05-25 22:453,500.595
942023-05-25 23:003,578.683
952023-05-25 23:152,517.467
962023-05-25 23:304,062.375
972023-05-25 23:452,915.498
982023-05-26 00:004,854.241
992023-05-26 00:153,374.123
1002023-05-26 00:304,202.271
1012023-05-26 00:453,801.963
1022023-05-26 01:003,879.035
1032023-05-26 01:154,299.921
1042023-05-26 01:303,615.864
1052023-05-26 01:453,510.851
1062023-05-26 02:003,736.593
1072023-05-26 02:154,055.021
1082023-05-26 02:302,786.757
1092023-05-26 02:452,505.937
1102023-05-26 03:003,293.731
1112023-05-26 03:153,164.893
1122023-05-26 03:304,638.357
1132023-05-26 03:453,140.272
1142023-05-26 04:003,613.675
1152023-05-26 04:154,805.370
1162023-05-26 04:304,007.973
1172023-05-26 04:454,799.437
1182023-05-26 05:003,540.563
1192023-05-26 05:152,796.180
1202023-05-26 05:303,409.344
1212023-05-26 05:454,932.527
1222023-05-26 06:002,621.287
1232023-05-26 06:153,083.597
1242023-05-26 06:303,135.494
1252023-05-26 06:453,749.298
1262023-05-26 07:003,617.735
1272023-05-26 07:154,842.609
1282023-05-26 07:302,675.325
1292023-05-26 07:453,597.158
1302023-05-26 08:002,540.299
1312023-05-26 08:154,957.967
1322023-05-26 08:304,076.378
1332023-05-26 08:454,851.608
1342023-05-26 09:004,246.061
1352023-05-26 09:153,144.135
1362023-05-26 09:303,667.679
1372023-05-26 09:454,875.599
1382023-05-26 10:004,687.647
1392023-05-26 10:152,923.376
1402023-05-26 10:304,818.846
1412023-05-26 10:453,585.311
1422023-05-26 11:003,801.031
1432023-05-26 11:152,927.190
1442023-05-26 11:302,541.055
1452023-05-26 11:454,970.960
1462023-05-26 12:003,253.313
1472023-05-26 12:154,844.542
1482023-05-26 12:302,571.619
1492023-05-26 12:454,052.134
1502023-05-26 13:003,356.909
1512023-05-26 13:153,139.740
1522023-05-26 13:303,516.037
1532023-05-26 13:454,284.775
1542023-05-26 14:004,923.858
1552023-05-26 14:152,959.095
1562023-05-26 14:302,760.923
1572023-05-26 14:453,159.566
1582023-05-26 15:003,829.724
1592023-05-26 15:152,563.510
1602023-05-26 15:303,253.971
1612023-05-26 15:454,322.738
1622023-05-26 16:004,764.061
1632023-05-26 16:153,890.872
1642023-05-26 16:302,754.680
1652023-05-26 16:452,899.037
1662023-05-26 17:003,113.563
1672023-05-26 17:152,970.902
1682023-05-26 17:304,951.536
1692023-05-26 17:454,596.098
1702023-05-26 18:004,878.535
1712023-05-26 18:153,929.126
1722023-05-26 18:303,582.341
1732023-05-26 18:454,207.872
1742023-05-26 19:003,496.071
1752023-05-26 19:154,934.956
1762023-05-26 19:304,733.501
1772023-05-26 19:454,654.295
1782023-05-26 20:004,760.982
1792023-05-26 20:153,293.795
1802023-05-26 20:303,872.873
1812023-05-26 20:454,414.687
1822023-05-26 21:004,107.595
1832023-05-26 21:152,859.311
1842023-05-26 21:304,622.270
1852023-05-26 21:454,419.287
1862023-05-26 22:003,691.419
1872023-05-26 22:153,078.195
1882023-05-26 22:304,651.941
1892023-05-26 22:453,988.712
1902023-05-26 23:002,813.172
1912023-05-26 23:153,856.650
1922023-05-26 23:304,300.160
1932023-05-26 23:452,808.670
1942023-05-27 00:002,853.819
1952023-05-27 00:154,085.773
1962023-05-27 00:303,124.999
1972023-05-27 00:454,357.455
1982023-05-27 01:003,580.518
1992023-05-27 01:154,176.435
2002023-05-27 01:303,663.732
2012023-05-27 01:454,269.002
2022023-05-27 02:004,307.188
2032023-05-27 02:153,424.705
2042023-05-27 02:302,810.704
2052023-05-27 02:454,483.003
2062023-05-27 03:004,464.391
2072023-05-27 03:154,936.221
2082023-05-27 03:303,931.213
2092023-05-27 03:453,135.548
2102023-05-27 04:004,887.896
2112023-05-27 04:154,707.776
2122023-05-27 04:303,255.956
2132023-05-27 04:453,383.180
2142023-05-27 05:004,542.526
2152023-05-27 05:152,998.649
2162023-05-27 05:304,896.142
2172023-05-27 05:454,841.498
2182023-05-27 06:004,036.712
2192023-05-27 06:154,124.787
2202023-05-27 06:304,283.040
2212023-05-27 06:454,582.141
2222023-05-27 07:003,633.025
2232023-05-27 07:153,351.614
2242023-05-27 07:302,515.021
2252023-05-27 07:453,917.319
2262023-05-27 08:004,888.188
2272023-05-27 08:154,996.003
2282023-05-27 08:302,572.069
2292023-05-27 08:453,686.220
2302023-05-27 09:003,391.679
2312023-05-27 09:153,957.418
2322023-05-27 09:303,375.660
2332023-05-27 09:454,614.300
2342023-05-27 10:002,755.170
2352023-05-27 10:154,609.192
2362023-05-27 10:304,975.713
2372023-05-27 10:453,937.816
2382023-05-27 11:004,180.184
2392023-05-27 11:153,395.402
2402023-05-27 11:302,568.701
2412023-05-27 11:454,956.661
2422023-05-27 12:004,572.909
2432023-05-27 12:154,870.264
2442023-05-27 12:304,749.312
2452023-05-27 12:454,700.538
2462023-05-27 13:004,960.593
2472023-05-27 13:153,166.258
2482023-05-27 13:304,278.986
2492023-05-27 13:454,936.318
2502023-05-27 14:004,143.954
2512023-05-27 14:152,555.252
2522023-05-27 14:304,690.834
2532023-05-27 14:453,637.657
2542023-05-27 15:003,513.479
2552023-05-27 15:153,349.227
2562023-05-27 15:303,975.166
2572023-05-27 15:454,506.404
2582023-05-27 16:002,523.085
2592023-05-27 16:153,441.484
2602023-05-27 16:304,776.012
2612023-05-27 16:453,459.081
2622023-05-27 17:004,836.390
2632023-05-27 17:152,752.382
2642023-05-27 17:303,342.067
2652023-05-27 17:454,749.390
2662023-05-27 18:003,946.333
2672023-05-27 18:152,946.789
2682023-05-27 18:304,442.373
2692023-05-27 18:454,145.994
2702023-05-27 19:003,340.135
2712023-05-27 19:152,565.145
2722023-05-27 19:302,834.078
2732023-05-27 19:452,554.646
2742023-05-27 20:002,732.058
2752023-05-27 20:154,689.157
2762023-05-27 20:304,906.193
2772023-05-27 20:454,419.924
2782023-05-27 21:004,181.468
2792023-05-27 21:152,837.234
2802023-05-27 21:304,775.140
2812023-05-27 21:452,769.375
2822023-05-27 22:002,789.085
2832023-05-27 22:154,977.658
2842023-05-27 22:302,881.141
2852023-05-27 22:452,912.858
2862023-05-27 23:003,491.305
2872023-05-27 23:153,143.691
2882023-05-27 23:303,084.180
2892023-05-27 23:454,495.195
2902023-05-28 00:003,809.750
2912023-05-28 00:153,758.614
2922023-05-28 00:303,798.959
2932023-05-28 00:454,940.421
2942023-05-28 01:002,919.216
2952023-05-28 01:154,123.632
2962023-05-28 01:303,857.419
2972023-05-28 01:453,160.531
2982023-05-28 02:004,870.645
2992023-05-28 02:152,658.773
3002023-05-28 02:303,707.175
3012023-05-28 02:453,938.097
3022023-05-28 03:004,848.035
3032023-05-28 03:153,040.145
3042023-05-28 03:304,988.218
3052023-05-28 03:454,687.774
3062023-05-28 04:004,854.480
3072023-05-28 04:154,698.772
3082023-05-28 04:303,334.346
3092023-05-28 04:454,269.153
3102023-05-28 05:004,685.021
3112023-05-28 05:154,339.982
3122023-05-28 05:302,816.996
3132023-05-28 05:452,892.156
3142023-05-28 06:002,506.396
3152023-05-28 06:153,074.940
3162023-05-28 06:303,596.034
3172023-05-28 06:453,974.216
3182023-05-28 07:003,159.727
3192023-05-28 07:152,907.092
3202023-05-28 07:304,718.050
3212023-05-28 07:453,079.479
3222023-05-28 08:004,589.698
3232023-05-28 08:154,529.480
3242023-05-28 08:303,109.199
3252023-05-28 08:454,735.634
3262023-05-28 09:002,697.443
3272023-05-28 09:153,180.370
3282023-05-28 09:303,820.325
3292023-05-28 09:454,259.579
3302023-05-28 10:002,830.298
3312023-05-28 10:154,077.685
3322023-05-28 10:302,593.408
3332023-05-28 10:453,439.681
3342023-05-28 11:004,155.010
3352023-05-28 11:153,323.551
3362023-05-28 11:304,350.591
3372023-05-28 11:453,395.538
3382023-05-28 12:004,488.074
3392023-05-28 12:152,502.892
3402023-05-28 12:303,418.300
3412023-05-28 12:454,042.614
3422023-05-28 13:004,738.530
3432023-05-28 13:154,865.609
3442023-05-28 13:303,264.728
3452023-05-28 13:453,492.816
3462023-05-28 14:003,195.093
3472023-05-28 14:154,717.353
3482023-05-28 14:302,980.781
3492023-05-28 14:452,592.815
3502023-05-28 15:004,507.734
3512023-05-28 15:153,188.615
fuelguy
Cell Formulas
RangeFormula
D2:D5D2=SUMIFS(B2:B351,A2:A351,">="&C2,A2:A351,"<"&C2+1)
Click to expand...
The bulk tank numbers are the current tank volume. They will usually be descending as the day goes on. Except when the tank gets filled and I can deal with that math.
 
Upvote 0
Okay, i'm not sure that is how you stated the question in the first post.
So you want to subtract the first reading of last day from first reading of the previous day?
How do you account when more fuel is added to the tank?
 
Upvote 0
awoohaw said:
Okay, i'm not sure that is how you stated the question in the first post.
So you want to subtract the first reading of last day from first reading of the previous day?
How do you account when more fuel is added to the tank?
Click to expand...
NM. I just re-read the last sentence of last post.
 
Upvote 0
okay,
try this:

The numbers are funny because I seeded the data with random numbers.

Mr excel questions 39.xlsm
ABCD
1timestamp(CDT)Bulk TankDay
22023-05-25 00:003,543.6842023-05-251310.557
32023-05-25 00:154,893.4182023-05-26-2000.422
42023-05-25 00:303,333.0332023-05-27955.931
52023-05-25 00:452,533.3652023-05-28
62023-05-25 01:002,629.453
72023-05-25 01:154,350.905
82023-05-25 01:304,509.426
92023-05-25 01:454,921.835
102023-05-25 02:003,951.869
112023-05-25 02:152,955.933
122023-05-25 02:303,556.592
132023-05-25 02:452,724.197
142023-05-25 03:004,675.121
152023-05-25 03:154,960.911
162023-05-25 03:302,609.553
172023-05-25 03:453,979.518
182023-05-25 04:002,617.946
192023-05-25 04:154,065.461
202023-05-25 04:304,367.874
212023-05-25 04:454,869.658
222023-05-25 05:004,626.680
232023-05-25 05:153,949.372
242023-05-25 05:303,801.736
252023-05-25 05:454,951.604
262023-05-25 06:004,148.688
272023-05-25 06:152,656.062
282023-05-25 06:303,695.410
292023-05-25 06:453,989.715
302023-05-25 07:002,745.707
312023-05-25 07:153,994.317
322023-05-25 07:304,176.630
332023-05-25 07:454,248.454
342023-05-25 08:002,678.433
352023-05-25 08:154,174.890
362023-05-25 08:304,935.301
372023-05-25 08:454,539.801
382023-05-25 09:003,949.855
392023-05-25 09:152,900.042
402023-05-25 09:303,270.960
412023-05-25 09:454,357.751
422023-05-25 10:004,705.759
432023-05-25 10:154,450.019
442023-05-25 10:304,296.972
452023-05-25 10:454,355.261
462023-05-25 11:004,536.933
472023-05-25 11:153,102.177
482023-05-25 11:303,048.015
492023-05-25 11:453,818.781
502023-05-25 12:002,574.317
512023-05-25 12:152,838.419
522023-05-25 12:303,746.814
532023-05-25 12:453,271.120
542023-05-25 13:004,927.723
552023-05-25 13:154,413.971
562023-05-25 13:304,923.701
572023-05-25 13:452,979.913
582023-05-25 14:004,278.016
592023-05-25 14:154,984.930
602023-05-25 14:303,830.401
612023-05-25 14:453,397.071
622023-05-25 15:004,242.609
632023-05-25 15:153,669.633
642023-05-25 15:304,699.492
652023-05-25 15:454,082.318
662023-05-25 16:003,111.400
672023-05-25 16:154,190.465
682023-05-25 16:304,452.069
692023-05-25 16:454,459.071
702023-05-25 17:003,740.578
712023-05-25 17:154,988.494
722023-05-25 17:302,874.251
732023-05-25 17:453,407.785
742023-05-25 18:003,909.316
752023-05-25 18:153,943.639
762023-05-25 18:304,508.493
772023-05-25 18:454,429.107
782023-05-25 19:003,203.962
792023-05-25 19:154,092.113
802023-05-25 19:302,744.391
812023-05-25 19:454,689.514
822023-05-25 20:004,833.582
832023-05-25 20:153,123.539
842023-05-25 20:302,539.090
852023-05-25 20:453,347.668
862023-05-25 21:003,973.561
872023-05-25 21:154,961.064
882023-05-25 21:303,248.690
892023-05-25 21:454,026.942
902023-05-25 22:003,367.006
912023-05-25 22:154,584.429
922023-05-25 22:303,371.675
932023-05-25 22:453,500.595
942023-05-25 23:003,578.683
952023-05-25 23:152,517.467
962023-05-25 23:304,062.375
972023-05-25 23:452,915.498
982023-05-26 00:004,854.241
992023-05-26 00:153,374.123
1002023-05-26 00:304,202.271
1012023-05-26 00:453,801.963
1022023-05-26 01:003,879.035
1032023-05-26 01:154,299.921
1042023-05-26 01:303,615.864
1052023-05-26 01:453,510.851
1062023-05-26 02:003,736.593
1072023-05-26 02:154,055.021
1082023-05-26 02:302,786.757
1092023-05-26 02:452,505.937
1102023-05-26 03:003,293.731
1112023-05-26 03:153,164.893
1122023-05-26 03:304,638.357
1132023-05-26 03:453,140.272
1142023-05-26 04:003,613.675
1152023-05-26 04:154,805.370
1162023-05-26 04:304,007.973
1172023-05-26 04:454,799.437
1182023-05-26 05:003,540.563
1192023-05-26 05:152,796.180
1202023-05-26 05:303,409.344
1212023-05-26 05:454,932.527
1222023-05-26 06:002,621.287
1232023-05-26 06:153,083.597
1242023-05-26 06:303,135.494
1252023-05-26 06:453,749.298
1262023-05-26 07:003,617.735
1272023-05-26 07:154,842.609
1282023-05-26 07:302,675.325
1292023-05-26 07:453,597.158
1302023-05-26 08:002,540.299
1312023-05-26 08:154,957.967
1322023-05-26 08:304,076.378
1332023-05-26 08:454,851.608
1342023-05-26 09:004,246.061
1352023-05-26 09:153,144.135
1362023-05-26 09:303,667.679
1372023-05-26 09:454,875.599
1382023-05-26 10:004,687.647
1392023-05-26 10:152,923.376
1402023-05-26 10:304,818.846
1412023-05-26 10:453,585.311
1422023-05-26 11:003,801.031
1432023-05-26 11:152,927.190
1442023-05-26 11:302,541.055
1452023-05-26 11:454,970.960
1462023-05-26 12:003,253.313
1472023-05-26 12:154,844.542
1482023-05-26 12:302,571.619
1492023-05-26 12:454,052.134
1502023-05-26 13:003,356.909
1512023-05-26 13:153,139.740
1522023-05-26 13:303,516.037
1532023-05-26 13:454,284.775
1542023-05-26 14:004,923.858
1552023-05-26 14:152,959.095
1562023-05-26 14:302,760.923
1572023-05-26 14:453,159.566
1582023-05-26 15:003,829.724
1592023-05-26 15:152,563.510
1602023-05-26 15:303,253.971
1612023-05-26 15:454,322.738
1622023-05-26 16:004,764.061
1632023-05-26 16:153,890.872
1642023-05-26 16:302,754.680
1652023-05-26 16:452,899.037
1662023-05-26 17:003,113.563
1672023-05-26 17:152,970.902
1682023-05-26 17:304,951.536
1692023-05-26 17:454,596.098
1702023-05-26 18:004,878.535
1712023-05-26 18:153,929.126
1722023-05-26 18:303,582.341
1732023-05-26 18:454,207.872
1742023-05-26 19:003,496.071
1752023-05-26 19:154,934.956
1762023-05-26 19:304,733.501
1772023-05-26 19:454,654.295
1782023-05-26 20:004,760.982
1792023-05-26 20:153,293.795
1802023-05-26 20:303,872.873
1812023-05-26 20:454,414.687
1822023-05-26 21:004,107.595
1832023-05-26 21:152,859.311
1842023-05-26 21:304,622.270
1852023-05-26 21:454,419.287
1862023-05-26 22:003,691.419
1872023-05-26 22:153,078.195
1882023-05-26 22:304,651.941
1892023-05-26 22:453,988.712
1902023-05-26 23:002,813.172
1912023-05-26 23:153,856.650
1922023-05-26 23:304,300.160
1932023-05-26 23:452,808.670
1942023-05-27 00:002,853.819
1952023-05-27 00:154,085.773
1962023-05-27 00:303,124.999
1972023-05-27 00:454,357.455
1982023-05-27 01:003,580.518
1992023-05-27 01:154,176.435
2002023-05-27 01:303,663.732
2012023-05-27 01:454,269.002
2022023-05-27 02:004,307.188
2032023-05-27 02:153,424.705
2042023-05-27 02:302,810.704
2052023-05-27 02:454,483.003
2062023-05-27 03:004,464.391
2072023-05-27 03:154,936.221
2082023-05-27 03:303,931.213
2092023-05-27 03:453,135.548
2102023-05-27 04:004,887.896
2112023-05-27 04:154,707.776
2122023-05-27 04:303,255.956
2132023-05-27 04:453,383.180
2142023-05-27 05:004,542.526
2152023-05-27 05:152,998.649
2162023-05-27 05:304,896.142
2172023-05-27 05:454,841.498
2182023-05-27 06:004,036.712
2192023-05-27 06:154,124.787
2202023-05-27 06:304,283.040
2212023-05-27 06:454,582.141
2222023-05-27 07:003,633.025
2232023-05-27 07:153,351.614
2242023-05-27 07:302,515.021
2252023-05-27 07:453,917.319
2262023-05-27 08:004,888.188
2272023-05-27 08:154,996.003
2282023-05-27 08:302,572.069
2292023-05-27 08:453,686.220
2302023-05-27 09:003,391.679
2312023-05-27 09:153,957.418
2322023-05-27 09:303,375.660
2332023-05-27 09:454,614.300
2342023-05-27 10:002,755.170
2352023-05-27 10:154,609.192
2362023-05-27 10:304,975.713
2372023-05-27 10:453,937.816
2382023-05-27 11:004,180.184
2392023-05-27 11:153,395.402
2402023-05-27 11:302,568.701
2412023-05-27 11:454,956.661
2422023-05-27 12:004,572.909
2432023-05-27 12:154,870.264
2442023-05-27 12:304,749.312
2452023-05-27 12:454,700.538
2462023-05-27 13:004,960.593
2472023-05-27 13:153,166.258
2482023-05-27 13:304,278.986
2492023-05-27 13:454,936.318
2502023-05-27 14:004,143.954
2512023-05-27 14:152,555.252
2522023-05-27 14:304,690.834
2532023-05-27 14:453,637.657
2542023-05-27 15:003,513.479
2552023-05-27 15:153,349.227
2562023-05-27 15:303,975.166
2572023-05-27 15:454,506.404
2582023-05-27 16:002,523.085
2592023-05-27 16:153,441.484
2602023-05-27 16:304,776.012
2612023-05-27 16:453,459.081
2622023-05-27 17:004,836.390
2632023-05-27 17:152,752.382
2642023-05-27 17:303,342.067
2652023-05-27 17:454,749.390
2662023-05-27 18:003,946.333
2672023-05-27 18:152,946.789
2682023-05-27 18:304,442.373
2692023-05-27 18:454,145.994
2702023-05-27 19:003,340.135
2712023-05-27 19:152,565.145
2722023-05-27 19:302,834.078
2732023-05-27 19:452,554.646
2742023-05-27 20:002,732.058
2752023-05-27 20:154,689.157
2762023-05-27 20:304,906.193
2772023-05-27 20:454,419.924
2782023-05-27 21:004,181.468
2792023-05-27 21:152,837.234
2802023-05-27 21:304,775.140
2812023-05-27 21:452,769.375
2822023-05-27 22:002,789.085
2832023-05-27 22:154,977.658
2842023-05-27 22:302,881.141
2852023-05-27 22:452,912.858
2862023-05-27 23:003,491.305
2872023-05-27 23:153,143.691
2882023-05-27 23:303,084.180
2892023-05-27 23:454,495.195
2902023-05-28 00:003,809.750
2912023-05-28 00:153,758.614
2922023-05-28 00:303,798.959
2932023-05-28 00:454,940.421
2942023-05-28 01:002,919.216
2952023-05-28 01:154,123.632
2962023-05-28 01:303,857.419
2972023-05-28 01:453,160.531
2982023-05-28 02:004,870.645
2992023-05-28 02:152,658.773
3002023-05-28 02:303,707.175
3012023-05-28 02:453,938.097
3022023-05-28 03:004,848.035
3032023-05-28 03:153,040.145
3042023-05-28 03:304,988.218
3052023-05-28 03:454,687.774
3062023-05-28 04:004,854.480
3072023-05-28 04:154,698.772
3082023-05-28 04:303,334.346
3092023-05-28 04:454,269.153
3102023-05-28 05:004,685.021
3112023-05-28 05:154,339.982
3122023-05-28 05:302,816.996
3132023-05-28 05:452,892.156
3142023-05-28 06:002,506.396
3152023-05-28 06:153,074.940
3162023-05-28 06:303,596.034
3172023-05-28 06:453,974.216
3182023-05-28 07:003,159.727
3192023-05-28 07:152,907.092
3202023-05-28 07:304,718.050
3212023-05-28 07:453,079.479
3222023-05-28 08:004,589.698
3232023-05-28 08:154,529.480
3242023-05-28 08:303,109.199
3252023-05-28 08:454,735.634
3262023-05-28 09:002,697.443
3272023-05-28 09:153,180.370
3282023-05-28 09:303,820.325
3292023-05-28 09:454,259.579
3302023-05-28 10:002,830.298
3312023-05-28 10:154,077.685
3322023-05-28 10:302,593.408
3332023-05-28 10:453,439.681
3342023-05-28 11:004,155.010
3352023-05-28 11:153,323.551
3362023-05-28 11:304,350.591
3372023-05-28 11:453,395.538
3382023-05-28 12:004,488.074
3392023-05-28 12:152,502.892
3402023-05-28 12:303,418.300
3412023-05-28 12:454,042.614
3422023-05-28 13:004,738.530
3432023-05-28 13:154,865.609
3442023-05-28 13:303,264.728
3452023-05-28 13:453,492.816
3462023-05-28 14:003,195.093
3472023-05-28 14:154,717.353
3482023-05-28 14:302,980.781
3492023-05-28 14:452,592.815
3502023-05-28 15:004,507.734
3512023-05-28 15:153,188.615
fuelguy
Cell Formulas
RangeFormula
D2:D4D2= INDEX(B2:B351,MATCH((1/LARGE(IFERROR(1/((--($C2+1=INT(A2:A351)))*(A2:A351)),0),1)),A2:A351,0),1)- INDEX(B2:B351,MATCH((1/LARGE(IFERROR(1/((--($C2=INT(A2:A351)))*(A2:A351)),0),1)),A2:A351,0),1)
 
Upvote 0
I had some things backwards above. So, I seeded the tank contents in descending order.
this may look better:

Mr excel questions 39.xlsm
ABCD
1timestamp(CDT)Bulk TankDay
22023-05-25 00:003,543.6842023-05-252883.350433
32023-05-25 00:153,481.5262023-05-26539.4528357
42023-05-25 00:303,423.4442023-05-2798.78095707
52023-05-25 00:453,357.6952023-05-28
62023-05-25 01:003,295.218
72023-05-25 01:153,239.219
82023-05-25 01:303,181.075
92023-05-25 01:453,127.670
102023-05-25 02:003,071.047
112023-05-25 02:153,009.704
122023-05-25 02:302,953.658
132023-05-25 02:452,907.594
142023-05-25 03:002,861.550
152023-05-25 03:152,806.744
162023-05-25 03:302,763.302
172023-05-25 03:452,718.554
182023-05-25 04:002,671.225
192023-05-25 04:152,621.220
202023-05-25 04:302,578.079
212023-05-25 04:452,537.090
222023-05-25 05:002,489.378
232023-05-25 05:152,448.983
242023-05-25 05:302,408.421
252023-05-25 05:452,369.325
262023-05-25 06:002,322.043
272023-05-25 06:152,277.456
282023-05-25 06:302,233.533
292023-05-25 06:452,193.327
302023-05-25 07:002,160.076
312023-05-25 07:152,122.096
322023-05-25 07:302,090.101
332023-05-25 07:452,057.172
342023-05-25 08:002,020.368
352023-05-25 08:151,988.729
362023-05-25 08:301,956.276
372023-05-25 08:451,918.235
382023-05-25 09:001,880.979
392023-05-25 09:151,849.040
402023-05-25 09:301,821.186
412023-05-25 09:451,792.604
422023-05-25 10:001,765.008
432023-05-25 10:151,737.434
442023-05-25 10:301,709.425
452023-05-25 10:451,675.923
462023-05-25 11:001,648.149
472023-05-25 11:151,620.518
482023-05-25 11:301,593.028
492023-05-25 11:451,564.644
502023-05-25 12:001,537.275
512023-05-25 12:151,509.294
522023-05-25 12:301,481.326
532023-05-25 12:451,451.944
542023-05-25 13:001,423.428
552023-05-25 13:151,399.174
562023-05-25 13:301,374.462
572023-05-25 13:451,351.779
582023-05-25 14:001,327.644
592023-05-25 14:151,306.928
602023-05-25 14:301,282.221
612023-05-25 14:451,257.867
622023-05-25 15:001,234.237
632023-05-25 15:151,212.420
642023-05-25 15:301,188.988
652023-05-25 15:451,169.669
662023-05-25 16:001,151.749
672023-05-25 16:151,129.315
682023-05-25 16:301,110.815
692023-05-25 16:451,093.057
702023-05-25 17:001,071.972
712023-05-25 17:151,051.794
722023-05-25 17:301,035.846
732023-05-25 17:451,019.684
742023-05-25 18:001,001.477
752023-05-25 18:15985.945
762023-05-25 18:30969.944
772023-05-25 18:45953.126
782023-05-25 19:00936.942
792023-05-25 19:15919.641
802023-05-25 19:30901.791
812023-05-25 19:45887.483
822023-05-25 20:00870.422
832023-05-25 20:15854.003
842023-05-25 20:30839.062
852023-05-25 20:45825.233
862023-05-25 21:00812.463
872023-05-25 21:15799.998
882023-05-25 21:30786.141
892023-05-25 21:45772.974
902023-05-25 22:00758.446
912023-05-25 22:15745.195
922023-05-25 22:30733.432
932023-05-25 22:45720.713
942023-05-25 23:00709.510
952023-05-25 23:15695.898
962023-05-25 23:30684.321
972023-05-25 23:45671.477
982023-05-26 00:00660.334
992023-05-26 00:15649.796
1002023-05-26 00:30638.543
1012023-05-26 00:45626.526
1022023-05-26 01:00616.706
1032023-05-26 01:15606.068
1042023-05-26 01:30594.212
1052023-05-26 01:45582.400
1062023-05-26 02:00573.168
1072023-05-26 02:15562.428
1082023-05-26 02:30552.770
1092023-05-26 02:45542.009
1102023-05-26 03:00531.185
1112023-05-26 03:15521.546
1122023-05-26 03:30513.633
1132023-05-26 03:45505.478
1142023-05-26 04:00497.394
1152023-05-26 04:15487.907
1162023-05-26 04:30479.983
1172023-05-26 04:45472.192
1182023-05-26 05:00464.580
1192023-05-26 05:15455.750
1202023-05-26 05:30448.539
1212023-05-26 05:45440.665
1222023-05-26 06:00432.816
1232023-05-26 06:15425.686
1242023-05-26 06:30417.535
1252023-05-26 06:45410.638
1262023-05-26 07:00403.995
1272023-05-26 07:15396.040
1282023-05-26 07:30389.116
1292023-05-26 07:45382.132
1302023-05-26 08:00374.628
1312023-05-26 08:15368.145
1322023-05-26 08:30361.310
1332023-05-26 08:45355.041
1342023-05-26 09:00349.219
1352023-05-26 09:15342.345
1362023-05-26 09:30336.263
1372023-05-26 09:45329.960
1382023-05-26 10:00324.835
1392023-05-26 10:15318.774
1402023-05-26 10:30313.177
1412023-05-26 10:45308.057
1422023-05-26 11:00303.320
1432023-05-26 11:15297.707
1442023-05-26 11:30292.744
1452023-05-26 11:45286.902
1462023-05-26 12:00281.424
1472023-05-26 12:15276.664
1482023-05-26 12:30271.995
1492023-05-26 12:45267.291
1502023-05-26 13:00262.175
1512023-05-26 13:15257.836
1522023-05-26 13:30253.037
1532023-05-26 13:45248.602
1542023-05-26 14:00244.132
1552023-05-26 14:15240.252
1562023-05-26 14:30235.912
1572023-05-26 14:45231.569
1582023-05-26 15:00227.715
1592023-05-26 15:15224.059
1602023-05-26 15:30219.733
1612023-05-26 15:45215.752
1622023-05-26 16:00211.795
1632023-05-26 16:15208.316
1642023-05-26 16:30204.839
1652023-05-26 16:45200.835
1662023-05-26 17:00197.746
1672023-05-26 17:15194.324
1682023-05-26 17:30191.075
1692023-05-26 17:45187.850
1702023-05-26 18:00184.631
1712023-05-26 18:15181.804
1722023-05-26 18:30179.019
1732023-05-26 18:45176.302
1742023-05-26 19:00172.914
1752023-05-26 19:15169.778
1762023-05-26 19:30166.878
1772023-05-26 19:45164.338
1782023-05-26 20:00161.601
1792023-05-26 20:15158.464
1802023-05-26 20:30155.548
1812023-05-26 20:45152.621
1822023-05-26 21:00150.130
1832023-05-26 21:15147.176
1842023-05-26 21:30144.666
1852023-05-26 21:45142.396
1862023-05-26 22:00139.715
1872023-05-26 22:15137.143
1882023-05-26 22:30134.564
1892023-05-26 22:45132.490
1902023-05-26 23:00130.058
1912023-05-26 23:15127.659
1922023-05-26 23:30125.371
1932023-05-26 23:45122.912
1942023-05-27 00:00120.881
1952023-05-27 00:15118.680
1962023-05-27 00:30116.393
1972023-05-27 00:45114.615
1982023-05-27 01:00112.431
1992023-05-27 01:15110.446
2002023-05-27 01:30108.749
2012023-05-27 01:45106.846
2022023-05-27 02:00105.186
2032023-05-27 02:15103.085
2042023-05-27 02:30101.439
2052023-05-27 02:4599.787
2062023-05-27 03:0097.990
2072023-05-27 03:1596.460
2082023-05-27 03:3094.961
2092023-05-27 03:4593.087
2102023-05-27 04:0091.683
2112023-05-27 04:1590.108
2122023-05-27 04:3088.351
2132023-05-27 04:4586.774
2142023-05-27 05:0085.362
2152023-05-27 05:1583.900
2162023-05-27 05:3082.471
2172023-05-27 05:4580.981
2182023-05-27 06:0079.554
2192023-05-27 06:1577.971
2202023-05-27 06:3076.701
2212023-05-27 06:4575.283
2222023-05-27 07:0073.902
2232023-05-27 07:1572.774
2242023-05-27 07:3071.424
2252023-05-27 07:4570.046
2262023-05-27 08:0068.834
2272023-05-27 08:1567.573
2282023-05-27 08:3066.554
2292023-05-27 08:4565.370
2302023-05-27 09:0064.187
2312023-05-27 09:1563.006
2322023-05-27 09:3061.869
2332023-05-27 09:4560.659
2342023-05-27 10:0059.520
2352023-05-27 10:1558.624
2362023-05-27 10:3057.640
2372023-05-27 10:4556.675
2382023-05-27 11:0055.818
2392023-05-27 11:1554.729
2402023-05-27 11:3053.814
2412023-05-27 11:4552.941
2422023-05-27 12:0052.057
2432023-05-27 12:1551.109
2442023-05-27 12:3050.256
2452023-05-27 12:4549.264
2462023-05-27 13:0048.385
2472023-05-27 13:1547.610
2482023-05-27 13:3046.875
2492023-05-27 13:4545.943
2502023-05-27 14:0045.150
2512023-05-27 14:1544.438
2522023-05-27 14:3043.583
2532023-05-27 14:4542.893
2542023-05-27 15:0042.074
2552023-05-27 15:1541.316
2562023-05-27 15:3040.570
2572023-05-27 15:4539.884
2582023-05-27 16:0039.131
2592023-05-27 16:1538.353
2602023-05-27 16:3037.596
2612023-05-27 16:4536.864
2622023-05-27 17:0036.310
2632023-05-27 17:1535.671
2642023-05-27 17:3035.083
2652023-05-27 17:4534.513
2662023-05-27 18:0033.825
2672023-05-27 18:1533.211
2682023-05-27 18:3032.548
2692023-05-27 18:4532.050
2702023-05-27 19:0031.559
2712023-05-27 19:1530.959
2722023-05-27 19:3030.494
2732023-05-27 19:4529.906
2742023-05-27 20:0029.384
2752023-05-27 20:1528.879
2762023-05-27 20:3028.394
2772023-05-27 20:4527.914
2782023-05-27 21:0027.357
2792023-05-27 21:1526.829
2802023-05-27 21:3026.347
2812023-05-27 21:4525.873
2822023-05-27 22:0025.438
2832023-05-27 22:1525.016
2842023-05-27 22:3024.587
2852023-05-27 22:4524.110
2862023-05-27 23:0023.651
2872023-05-27 23:1523.198
2882023-05-27 23:3022.837
2892023-05-27 23:4522.485
2902023-05-28 00:0022.100
2912023-05-28 00:1521.671
2922023-05-28 00:3021.341
2932023-05-28 00:4520.980
2942023-05-28 01:0020.601
2952023-05-28 01:1520.266
2962023-05-28 01:3019.933
2972023-05-28 01:4519.550
2982023-05-28 02:0019.216
2992023-05-28 02:1518.924
3002023-05-28 02:3018.548
3012023-05-28 02:4518.187
3022023-05-28 03:0017.875
3032023-05-28 03:1517.605
3042023-05-28 03:3017.332
3052023-05-28 03:4516.990
3062023-05-28 04:0016.671
3072023-05-28 04:1516.350
3082023-05-28 04:3016.047
3092023-05-28 04:4515.729
3102023-05-28 05:0015.476
3112023-05-28 05:1515.167
3122023-05-28 05:3014.888
3132023-05-28 05:4514.595
3142023-05-28 06:0014.323
3152023-05-28 06:1514.088
3162023-05-28 06:3013.858
3172023-05-28 06:4513.584
3182023-05-28 07:0013.371
3192023-05-28 07:1513.138
3202023-05-28 07:3012.916
3212023-05-28 07:4512.706
3222023-05-28 08:0012.511
3232023-05-28 08:1512.299
3242023-05-28 08:3012.064
3252023-05-28 08:4511.874
3262023-05-28 09:0011.660
3272023-05-28 09:1511.475
3282023-05-28 09:3011.277
3292023-05-28 09:4511.106
3302023-05-28 10:0010.922
3312023-05-28 10:1510.754
3322023-05-28 10:3010.586
3332023-05-28 10:4510.384
3342023-05-28 11:0010.183
3352023-05-28 11:1510.015
3362023-05-28 11:309.835
3372023-05-28 11:459.672
3382023-05-28 12:009.493
3392023-05-28 12:159.317
3402023-05-28 12:309.159
3412023-05-28 12:459.001
3422023-05-28 13:008.838
3432023-05-28 13:158.691
3442023-05-28 13:308.557
3452023-05-28 13:458.404
3462023-05-28 14:008.274
3472023-05-28 14:158.120
3482023-05-28 14:307.965
3492023-05-28 14:457.811
3502023-05-28 15:007.666
3512023-05-28 15:157.545
fuelguy
Cell Formulas
RangeFormula
D2:D4D2= INDEX(B2:B351,MATCH((1/LARGE(IFERROR(1/((--($C2=INT(A2:A351)))*(A2:A351)),0),1)),A2:A351,0),1)- INDEX(B2:B351,MATCH((1/LARGE(IFERROR(1/((--($C2+1=INT(A2:A351)))*(A2:A351)),0),1)),A2:A351,0),1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Water Bill Calculator w/ROI from Percentage Savings
Replies
1
Views
65
Jared016
J
K
  • Solved
Macro to match sheet reference in formula to workbook sheet
Replies
6
Views
166
Peter_SSs
Peter_SSs
J
  • Question
Count cells below certain times
Replies
6
Views
142
etaf
etaf
K
  • Question
Code or something else to extract data
Replies
2
Views
122
Kim B
K
O
  • Question
Count only one occurrence of all criteria being met
Replies
8
Views
444
KRice
K

Forum statistics

Threads
1,215,069
Messages
6,122,958
Members
449,096
Latest member
Anshu121

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top