Dhinakaran
New Member
- Joined
- Mar 30, 2016
- Messages
- 48
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Hi All,
Need your suggestion on preparing a report for a 24 hours period i.e, from 6 AM to 6 AM or 7 AM to 7 AM.
For instance, lets assume that i have complete data for February-2022 period and the transaction have been made through the day.
- I need to identify a day sales value (i.e, from 1-Feb 7 AM to 2-Feb 7 AM).
- When I do this through a pivot table, the total sales value populated is combined for the complete 24 hours period on both these days (i.e, 1-Feb and 2-Feb).
- As a result I need to manually prepare the required data.
Do find the below sample for reference.
Need your suggestion on preparing a report for a 24 hours period i.e, from 6 AM to 6 AM or 7 AM to 7 AM.
For instance, lets assume that i have complete data for February-2022 period and the transaction have been made through the day.
- I need to identify a day sales value (i.e, from 1-Feb 7 AM to 2-Feb 7 AM).
- When I do this through a pivot table, the total sales value populated is combined for the complete 24 hours period on both these days (i.e, 1-Feb and 2-Feb).
- As a result I need to manually prepare the required data.
Do find the below sample for reference.
Created Date | Sales Value |
03-02-2022 23:38:00 | 339400 |
03-02-2022 23:35:08 | 339500 |
03-02-2022 23:29:17 | 339600 |
03-02-2022 23:27:23 | 339700 |
03-02-2022 23:22:55 | 339800 |
03-02-2022 23:22:00 | 339900 |
03-02-2022 23:04:43 | 340000 |
03-02-2022 21:50:41 | 340100 |
03-02-2022 21:41:33 | 340200 |
03-02-2022 21:35:19 | 340300 |
03-02-2022 21:35:00 | 340400 |
03-02-2022 21:32:13 | 340500 |
03-02-2022 21:26:47 | 340600 |
03-02-2022 21:26:02 | 340700 |
03-02-2022 21:14:43 | 340800 |
03-02-2022 21:13:36 | 340900 |
03-02-2022 21:05:23 | 341000 |
03-02-2022 21:00:48 | 341100 |
03-02-2022 20:55:50 | 341200 |
03-02-2022 20:54:16 | 341300 |
03-02-2022 20:38:08 | 341400 |
03-02-2022 20:09:15 | 341500 |
03-02-2022 20:06:35 | 341600 |
03-02-2022 20:03:33 | 341700 |
03-02-2022 20:02:21 | 341800 |
03-02-2022 20:01:49 | 341900 |
03-02-2022 19:49:36 | 342000 |
03-02-2022 19:48:36 | 342100 |
03-02-2022 19:46:31 | 342200 |
03-02-2022 19:45:42 | 342300 |
03-02-2022 19:43:13 | 342400 |
03-02-2022 19:31:14 | 342500 |
03-02-2022 19:28:08 | 342600 |
03-02-2022 19:27:00 | 342700 |
03-02-2022 19:25:26 | 342800 |
03-02-2022 19:20:17 | 342900 |
03-02-2022 19:20:07 | 343000 |
03-02-2022 19:11:44 | 343100 |
03-02-2022 19:02:57 | 343200 |
03-02-2022 18:46:12 | 343300 |
03-02-2022 18:32:44 | 343400 |
03-02-2022 18:19:56 | 343500 |
03-02-2022 18:15:30 | 343600 |
03-02-2022 18:14:38 | 343700 |
03-02-2022 18:10:12 | 343800 |
03-02-2022 18:07:25 | 343900 |
03-02-2022 18:05:18 | 344000 |
03-02-2022 17:47:36 | 344100 |
03-02-2022 17:43:42 | 344200 |
03-02-2022 16:59:00 | 344300 |
03-02-2022 16:58:41 | 344400 |
03-02-2022 16:56:39 | 344500 |
03-02-2022 16:54:58 | 344600 |
03-02-2022 16:49:29 | 344700 |
03-02-2022 14:37:54 | 344800 |
03-02-2022 14:31:52 | 344900 |
03-02-2022 14:20:07 | 345000 |
03-02-2022 14:18:28 | 345100 |
03-02-2022 13:58:11 | 345200 |
03-02-2022 13:56:54 | 345300 |
03-02-2022 13:17:12 | 345400 |
03-02-2022 13:15:46 | 345500 |
03-02-2022 13:05:47 | 345600 |
03-02-2022 13:03:31 | 345700 |
03-02-2022 12:58:58 | 345800 |
03-02-2022 12:56:07 | 345900 |
03-02-2022 12:50:16 | 346000 |
03-02-2022 12:39:35 | 346100 |
03-02-2022 12:32:27 | 346200 |
03-02-2022 12:24:04 | 346300 |
03-02-2022 12:16:00 | 346400 |
03-02-2022 12:12:07 | 346500 |
03-02-2022 12:05:05 | 346600 |
03-02-2022 11:54:49 | 346700 |
03-02-2022 11:46:29 | 346800 |
03-02-2022 11:16:25 | 346900 |
03-02-2022 11:07:18 | 347000 |
03-02-2022 11:00:48 | 347100 |
03-02-2022 10:49:26 | 347200 |
03-02-2022 10:41:42 | 347300 |
03-02-2022 10:35:50 | 347400 |
03-02-2022 10:34:07 | 347500 |
03-02-2022 10:31:45 | 347600 |
03-02-2022 10:14:01 | 347700 |
03-02-2022 10:11:38 | 347800 |
03-02-2022 10:05:15 | 347900 |
03-02-2022 10:02:26 | 348000 |
03-02-2022 09:59:46 | 348100 |
03-02-2022 09:58:12 | 348200 |
03-02-2022 00:05:11 | 348300 |
03-02-2022 00:01:13 | 348400 |
02-02-2022 23:45:21 | 348500 |
02-02-2022 23:45:17 | 348600 |
02-02-2022 23:26:02 | 348700 |
02-02-2022 23:21:26 | 348800 |
02-02-2022 23:10:10 | 348900 |
02-02-2022 22:50:37 | 349000 |
02-02-2022 22:47:28 | 349100 |
02-02-2022 22:46:41 | 349200 |
02-02-2022 22:43:58 | 349300 |
02-02-2022 22:40:10 | 349400 |
02-02-2022 22:25:33 | 349500 |
02-02-2022 22:23:51 | 349600 |
02-02-2022 22:23:46 | 349700 |
02-02-2022 22:21:09 | 349800 |
02-02-2022 22:20:57 | 349900 |
02-02-2022 22:19:03 | 350000 |
02-02-2022 22:18:30 | 350100 |
02-02-2022 22:17:15 | 350200 |
02-02-2022 22:14:55 | 350300 |
02-02-2022 21:36:26 | 350400 |
02-02-2022 21:34:42 | 350500 |
02-02-2022 21:33:11 | 350600 |
02-02-2022 21:25:38 | 350700 |
02-02-2022 21:24:50 | 350800 |
02-02-2022 21:18:53 | 350900 |
02-02-2022 20:42:40 | 351000 |
02-02-2022 20:40:44 | 351100 |
02-02-2022 20:36:22 | 351200 |
02-02-2022 20:35:59 | 351300 |
02-02-2022 20:33:30 | 351400 |
02-02-2022 20:33:26 | 351500 |
02-02-2022 20:30:14 | 351600 |
02-02-2022 20:25:00 | 351700 |
02-02-2022 20:01:39 | 351800 |
02-02-2022 19:56:14 | 351900 |
02-02-2022 19:54:59 | 352000 |
02-02-2022 19:53:49 | 352100 |
02-02-2022 19:53:23 | 352200 |
02-02-2022 19:52:26 | 352300 |
02-02-2022 19:51:30 | 352400 |
02-02-2022 19:45:33 | 352500 |
02-02-2022 19:43:40 | 352600 |
02-02-2022 19:41:56 | 352700 |
02-02-2022 19:38:29 | 352800 |
02-02-2022 19:38:25 | 352900 |
02-02-2022 19:31:45 | 353000 |
02-02-2022 19:30:34 | 353100 |
02-02-2022 19:27:15 | 353200 |
02-02-2022 19:25:18 | 353300 |
02-02-2022 19:12:48 | 353400 |
02-02-2022 19:11:39 | 353500 |
02-02-2022 19:10:32 | 353600 |
02-02-2022 19:05:51 | 353700 |
02-02-2022 19:03:37 | 353800 |
02-02-2022 19:01:18 | 353900 |
02-02-2022 19:00:28 | 354000 |
02-02-2022 19:00:02 | 354100 |
02-02-2022 18:57:36 | 354200 |
02-02-2022 18:38:32 | 354300 |
02-02-2022 18:36:30 | 354400 |
02-02-2022 18:32:05 | 354500 |
02-02-2022 18:31:10 | 354600 |
02-02-2022 18:29:47 | 354700 |
02-02-2022 18:21:00 | 354800 |
02-02-2022 18:20:45 | 354900 |
02-02-2022 18:17:59 | 355000 |
02-02-2022 18:17:44 | 355100 |
02-02-2022 18:15:15 | 355200 |
02-02-2022 18:07:13 | 355300 |
02-02-2022 17:58:48 | 355400 |
02-02-2022 17:58:08 | 355500 |
02-02-2022 17:32:17 | 355600 |
02-02-2022 17:29:28 | 355700 |
02-02-2022 17:24:27 | 355800 |
02-02-2022 17:20:22 | 355900 |
02-02-2022 17:15:53 | 356000 |
02-02-2022 17:07:26 | 356100 |
02-02-2022 17:01:17 | 356200 |
02-02-2022 16:54:24 | 356300 |
02-02-2022 16:41:36 | 356400 |
02-02-2022 15:54:55 | 356500 |
02-02-2022 15:53:00 | 356600 |
02-02-2022 15:51:50 | 356700 |
02-02-2022 15:41:33 | 356800 |
02-02-2022 15:38:49 | 356900 |
02-02-2022 15:35:48 | 357000 |
02-02-2022 15:33:36 | 357100 |
02-02-2022 15:21:53 | 357200 |
02-02-2022 15:18:39 | 357300 |
02-02-2022 15:12:54 | 357400 |
02-02-2022 14:25:26 | 357500 |
02-02-2022 14:24:15 | 357600 |
02-02-2022 13:39:42 | 357700 |
02-02-2022 12:59:36 | 357800 |
02-02-2022 12:58:17 | 357900 |
02-02-2022 12:57:51 | 358000 |
02-02-2022 12:56:24 | 358100 |
02-02-2022 12:51:25 | 358200 |
02-02-2022 12:22:03 | 358300 |
02-02-2022 12:20:56 | 358400 |
02-02-2022 12:19:16 | 358500 |
02-02-2022 11:55:48 | 358600 |
02-02-2022 11:24:24 | 358700 |
02-02-2022 11:23:25 | 358800 |
02-02-2022 11:04:29 | 358900 |
02-02-2022 11:03:02 | 359000 |
02-02-2022 10:59:19 | 359100 |
02-02-2022 10:52:03 | 359200 |
02-02-2022 10:45:20 | 359300 |
02-02-2022 10:42:19 | 359400 |
02-02-2022 10:27:16 | 359500 |
02-02-2022 10:00:35 | 359600 |
02-02-2022 09:57:12 | 359700 |
02-02-2022 09:38:29 | 359800 |
02-02-2022 09:30:47 | 359900 |
02-02-2022 08:55:09 | 360000 |
02-02-2022 08:45:08 | 360100 |
02-02-2022 08:28:25 | 360200 |
02-02-2022 01:22:47 | 360300 |
02-02-2022 01:15:08 | 360400 |
02-02-2022 01:13:55 | 360500 |
02-02-2022 01:13:43 | 360600 |
02-02-2022 01:13:35 | 360700 |
02-02-2022 01:11:54 | 360800 |
02-02-2022 01:08:25 | 360900 |
02-02-2022 01:06:02 | 361000 |
02-02-2022 01:03:30 | 361100 |
02-02-2022 01:03:16 | 361200 |
02-02-2022 00:47:57 | 361300 |
02-02-2022 00:24:28 | 361400 |
02-02-2022 00:19:11 | 361500 |
01-02-2022 23:59:09 | 361600 |
01-02-2022 23:53:38 | 361700 |
01-02-2022 23:49:49 | 361800 |
01-02-2022 23:48:32 | 361900 |
01-02-2022 23:48:12 | 362000 |
01-02-2022 23:44:23 | 362100 |
01-02-2022 23:41:01 | 362200 |
01-02-2022 23:39:24 | 362300 |
01-02-2022 23:34:25 | 362400 |
01-02-2022 23:33:12 | 362500 |
01-02-2022 23:32:30 | 362600 |
01-02-2022 23:19:23 | 362700 |
01-02-2022 23:16:46 | 362800 |
01-02-2022 22:32:16 | 362900 |
01-02-2022 22:27:48 | 363000 |
01-02-2022 22:17:31 | 363100 |
01-02-2022 22:12:43 | 363200 |
01-02-2022 22:12:33 | 363300 |
01-02-2022 22:11:46 | 363400 |
01-02-2022 21:51:10 | 363500 |
01-02-2022 21:50:42 | 363600 |
01-02-2022 21:50:19 | 363700 |
01-02-2022 21:48:10 | 363800 |
01-02-2022 21:47:13 | 363900 |
01-02-2022 21:46:37 | 364000 |
01-02-2022 21:45:03 | 364100 |
01-02-2022 21:44:56 | 364200 |
01-02-2022 21:41:56 | 364300 |
01-02-2022 21:40:07 | 364400 |
01-02-2022 21:38:34 | 364500 |
01-02-2022 21:35:52 | 364600 |
01-02-2022 21:28:10 | 364700 |
01-02-2022 21:10:31 | 364800 |
01-02-2022 21:05:37 | 364900 |
01-02-2022 21:04:48 | 365000 |
01-02-2022 21:02:07 | 365100 |
01-02-2022 21:01:37 | 365200 |
01-02-2022 21:00:01 | 365300 |
01-02-2022 20:59:27 | 365400 |
01-02-2022 20:53:11 | 365500 |
01-02-2022 20:00:57 | 365600 |
01-02-2022 19:57:41 | 365700 |
01-02-2022 19:54:56 | 365800 |
01-02-2022 19:52:26 | 365900 |
01-02-2022 19:51:21 | 366000 |
01-02-2022 19:49:36 | 366100 |
01-02-2022 19:48:23 | 366200 |
01-02-2022 19:47:09 | 366300 |
01-02-2022 19:46:50 | 366400 |
01-02-2022 19:45:50 | 366500 |
01-02-2022 19:45:09 | 366600 |
01-02-2022 19:41:29 | 366700 |
01-02-2022 19:29:07 | 366800 |
01-02-2022 19:28:16 | 366900 |
01-02-2022 19:17:44 | 367000 |
01-02-2022 19:16:16 | 367100 |
01-02-2022 19:11:48 | 367200 |
01-02-2022 19:07:34 | 367300 |
01-02-2022 19:03:04 | 367400 |
01-02-2022 18:57:08 | 367500 |
01-02-2022 18:23:22 | 367600 |
01-02-2022 18:17:51 | 367700 |
01-02-2022 17:19:59 | 367800 |
01-02-2022 17:18:18 | 367900 |
01-02-2022 17:03:29 | 368000 |
01-02-2022 16:55:43 | 368100 |
01-02-2022 16:47:11 | 368200 |
01-02-2022 16:45:29 | 368300 |
01-02-2022 16:41:25 | 368400 |
01-02-2022 16:27:43 | 368500 |
01-02-2022 16:12:13 | 368600 |
01-02-2022 16:03:13 | 368700 |
01-02-2022 15:40:15 | 368800 |
01-02-2022 15:24:11 | 368900 |
01-02-2022 15:17:49 | 369000 |
01-02-2022 14:02:40 | 369100 |
01-02-2022 13:58:22 | 369200 |
01-02-2022 12:57:12 | 369300 |
01-02-2022 12:33:40 | 369400 |
01-02-2022 12:28:49 | 369500 |
01-02-2022 12:27:07 | 369600 |
01-02-2022 10:55:29 | 369700 |
01-02-2022 10:35:28 | 369800 |
01-02-2022 10:30:20 | 369900 |
01-02-2022 10:25:18 | 370000 |
01-02-2022 10:19:42 | 370100 |
01-02-2022 10:14:59 | 370200 |
01-02-2022 10:07:09 | 370300 |
01-02-2022 10:02:17 | 370400 |
01-02-2022 09:49:24 | 370500 |
01-02-2022 08:38:32 | 370600 |
01-02-2022 08:34:07 | 370700 |
01-02-2022 08:30:39 | 370800 |
01-02-2022 08:26:12 | 370900 |
01-02-2022 08:21:32 | 371000 |
01-02-2022 08:15:16 | 371100 |
01-02-2022 08:09:57 | 371200 |
01-02-2022 08:03:37 | 371300 |
01-02-2022 07:58:02 | 371400 |
01-02-2022 03:30:13 | 371500 |
01-02-2022 03:25:07 | 371600 |
01-02-2022 03:20:08 | 371700 |
01-02-2022 03:15:37 | 371800 |
01-02-2022 03:08:33 | 371900 |
01-02-2022 01:32:36 | 372000 |
01-02-2022 01:20:32 | 372100 |
01-02-2022 01:18:06 | 372200 |
01-02-2022 01:11:45 | 372300 |
01-02-2022 01:11:33 | 372400 |
01-02-2022 01:07:47 | 372500 |
01-02-2022 01:04:11 | 372600 |
01-02-2022 01:03:12 | 372700 |
01-02-2022 00:56:33 | 372800 |
01-02-2022 00:51:52 | 372900 |
01-02-2022 00:50:08 | 373000 |
01-02-2022 00:43:57 | 373100 |
01-02-2022 00:43:00 | 373200 |
01-02-2022 00:34:32 | 373300 |