Separate and transfer data in different sheet of same workbook based on criteria using macro

Status
Not open for further replies.

Muhammad Hussaan

New Member
Joined
Dec 13, 2017
Messages
49
Office Version
  1. 2013
Platform
  1. Windows
Hello,
I need help for the below task i am doing manually, and want to change it to excel macro/vba.
I have data in "Sheet 1" data in two columns D&E range D5:E4324, in D column there is date and time and in column E there is true and false; true means machine is running & false means machine is not running. The data is auto generated and keeps history of last 14 days.
The same file has sheets 1,2,3,4,5 upto 31 for the days of month. Current month on each sheet is available in cell M2 as (1,2,3... depending on the month)
Each sheet has portions of shift 1, shift 2 and shift 3
Normally we have maximum of six stoppages in a shift so i have made the sheets accordingly
Column B is start time Column C is end time
for shift 1 range is B9:C14
for shift 2 range is B16:C21
for shift 3 range is B23:C28
Each day has three shifts (Production Day start at 6:31 and end 6:30 date of start and end will be different)
Shift 1 Start 6:31 Shift 1 end 14:30
Shift 2 start 14:31 Shift 2 end 22:30
Shift 3 start 22:31 Shift 3 end 6:30
Objective is to record the start and stop time "False" whenever false start and ends, and place the start and end time on the basis of shift1, Shift 2, and Shift 3 and day sheet number and look month also.
For example in below data the data will go to sheet 24 and shift1 first event start of machine stop false is 8:10 and end at 9:00 and should not overwrite the data of sheet that is not available
As data range D5:E4324; Below is the sample data for understanding
2023-02-24 06:30:00​
TRUE​
2023-02-24 06:35:00​
TRUE​
2023-02-24 06:40:00​
TRUE​
2023-02-24 06:45:00​
TRUE​
2023-02-24 06:50:00​
TRUE​
2023-02-24 06:55:00​
TRUE​
2023-02-24 07:00:00​
TRUE​
2023-02-24 07:05:00​
TRUE​
2023-02-24 07:10:00​
TRUE​
2023-02-24 07:15:00​
TRUE​
2023-02-24 07:20:00​
TRUE​
2023-02-24 07:25:00​
TRUE​
2023-02-24 07:30:00​
TRUE​
2023-02-24 07:35:00​
TRUE​
2023-02-24 07:40:00​
TRUE​
2023-02-24 07:45:00​
TRUE​
2023-02-24 07:50:00​
TRUE​
2023-02-24 07:55:00​
TRUE​
2023-02-24 08:00:00​
TRUE​
2023-02-24 08:05:00​
TRUE​
2023-02-24 08:10:00​
FALSE​
2023-02-24 08:15:00​
FALSE​
2023-02-24 08:20:00​
FALSE​
2023-02-24 08:25:00​
FALSE​
2023-02-24 08:30:00​
FALSE​
2023-02-24 08:35:00​
FALSE​
2023-02-24 08:40:00​
FALSE​
2023-02-24 08:45:00​
FALSE​
2023-02-24 08:50:00​
FALSE​
2023-02-24 08:55:00​
FALSE​
2023-02-24 09:00:00​
FALSE​
2023-02-24 09:05:00​
TRUE​
2023-02-24 09:10:00​
TRUE​
2023-02-24 09:15:00​
TRUE​
2023-02-24 09:20:00​
TRUE​
2023-02-24 09:25:00​
TRUE​
2023-02-24 09:30:00​
TRUE​
2023-02-24 09:35:00​
TRUE​
2023-02-24 09:40:00​
TRUE​
2023-02-24 09:45:00​
TRUE​
2023-02-24 09:50:00​
TRUE​
2023-02-24 09:55:00​
TRUE​
2023-02-24 10:00:00​
TRUE​
2023-02-24 10:05:00​
TRUE​
2023-02-24 10:10:00​
TRUE​
2023-02-24 10:15:00​
TRUE​
2023-02-24 10:20:00​
TRUE​
2023-02-24 10:25:00​
TRUE​
2023-02-24 10:30:00​
TRUE​
2023-02-24 10:35:00​
TRUE​
2023-02-24 10:40:00​
TRUE​
2023-02-24 10:45:00​
TRUE​
2023-02-24 10:50:00​
TRUE​
2023-02-24 10:55:00​
TRUE​
2023-02-24 11:00:00​
TRUE​
2023-02-24 11:05:00​
TRUE​
2023-02-24 11:10:00​
TRUE​
2023-02-24 11:15:00​
TRUE​
2023-02-24 11:20:00​
TRUE​
2023-02-24 11:25:00​
TRUE​
2023-02-24 11:30:00​
TRUE​
2023-02-24 11:35:00​
TRUE​
2023-02-24 11:40:00​
TRUE​
2023-02-24 11:45:00​
TRUE​
2023-02-24 11:50:00​
TRUE​
2023-02-24 11:55:00​
TRUE​
2023-02-24 12:00:00​
TRUE​
2023-02-24 12:05:00​
TRUE​
2023-02-24 12:10:00​
TRUE​
2023-02-24 12:15:00​
TRUE​
2023-02-24 12:20:00​
TRUE​
2023-02-24 12:25:00​
TRUE​
2023-02-24 12:30:00​
TRUE​
2023-02-24 12:35:00​
TRUE​
2023-02-24 12:40:00​
TRUE​
2023-02-24 12:45:00​
TRUE​
2023-02-24 12:50:00​
TRUE​
2023-02-24 12:55:00​
TRUE​
2023-02-24 13:00:00​
TRUE​
2023-02-24 13:05:00​
TRUE​
2023-02-24 13:10:00​
TRUE​
2023-02-24 13:15:00​
TRUE​
2023-02-24 13:20:00​
TRUE​
2023-02-24 13:25:00​
TRUE​
2023-02-24 13:30:00​
TRUE​
2023-02-24 13:35:00​
TRUE​
2023-02-24 13:40:00​
TRUE​
2023-02-24 13:45:00​
TRUE​
2023-02-24 13:50:00​
TRUE​
2023-02-24 13:55:00​
TRUE​
2023-02-24 14:00:00​
TRUE​
2023-02-24 14:05:00​
TRUE​
2023-02-24 14:10:00​
TRUE​
2023-02-24 14:15:00​
TRUE​
2023-02-24 14:20:00​
TRUE​
2023-02-24 14:25:00​
TRUE​
2023-02-24 14:30:00​
TRUE​
2023-02-24 14:35:00​
TRUE​
2023-02-24 14:40:00​
TRUE​
2023-02-24 14:45:00​
TRUE​
2023-02-24 14:50:00​
FALSE​
2023-02-24 14:55:00​
FALSE​
2023-02-24 15:00:00​
FALSE​
2023-02-24 15:05:00​
FALSE​
2023-02-24 15:10:00​
FALSE​
2023-02-24 15:15:00​
TRUE​
2023-02-24 15:20:00​
TRUE​
2023-02-24 15:25:00​
TRUE​
2023-02-24 15:30:00​
TRUE​
2023-02-24 15:35:00​
TRUE​
2023-02-24 15:40:00​
TRUE​
2023-02-24 15:45:00​
TRUE​
2023-02-24 15:50:00​
TRUE​
2023-02-24 15:55:00​
TRUE​
2023-02-24 16:00:00​
TRUE​
2023-02-24 16:05:00​
TRUE​
2023-02-24 16:10:00​
TRUE​
2023-02-24 16:15:00​
TRUE​
2023-02-24 16:20:00​
TRUE​
2023-02-24 16:25:00​
TRUE​
2023-02-24 16:30:00​
TRUE​
2023-02-24 16:35:00​
TRUE​
2023-02-24 16:40:00​
TRUE​
2023-02-24 16:45:00​
TRUE​
2023-02-24 16:50:00​
TRUE​
2023-02-24 16:55:00​
TRUE​
2023-02-24 17:00:00​
TRUE​
2023-02-24 17:05:00​
TRUE​
2023-02-24 17:10:00​
TRUE​
2023-02-24 17:15:00​
TRUE​
2023-02-24 17:20:00​
TRUE​
2023-02-24 17:25:00​
TRUE​
2023-02-24 17:30:00​
TRUE​
2023-02-24 17:35:00​
TRUE​
2023-02-24 17:40:00​
TRUE​
2023-02-24 17:45:00​
TRUE​
2023-02-24 17:50:00​
TRUE​
2023-02-24 17:55:00​
TRUE​
2023-02-24 18:00:00​
FALSE​
2023-02-24 18:05:00​
FALSE​
2023-02-24 18:10:00​
FALSE​
2023-02-24 18:15:00​
FALSE​
2023-02-24 18:20:00​
TRUE​
2023-02-24 18:25:00​
TRUE​
2023-02-24 18:30:00​
TRUE​
2023-02-24 18:35:00​
TRUE​
2023-02-24 18:40:00​
TRUE​
2023-02-24 18:45:00​
TRUE​
2023-02-24 18:50:00​
TRUE​
2023-02-24 18:55:00​
TRUE​
2023-02-24 19:00:00​
TRUE​
2023-02-24 19:05:00​
TRUE​
2023-02-24 19:10:00​
TRUE​
2023-02-24 19:15:00​
TRUE​
2023-02-24 19:20:00​
TRUE​
2023-02-24 19:25:00​
TRUE​
2023-02-24 19:30:00​
TRUE​
2023-02-24 19:35:00​
TRUE​
2023-02-24 19:40:00​
TRUE​
2023-02-24 19:45:00​
TRUE​
2023-02-24 19:50:00​
TRUE​
2023-02-24 19:55:00​
TRUE​
2023-02-24 20:00:00​
TRUE​
2023-02-24 20:05:00​
TRUE​
2023-02-24 20:10:00​
TRUE​
2023-02-24 20:15:00​
TRUE​
2023-02-24 20:20:00​
TRUE​
2023-02-24 20:25:00​
TRUE​
2023-02-24 20:30:00​
TRUE​
2023-02-24 20:35:00​
TRUE​
2023-02-24 20:40:00​
TRUE​
2023-02-24 20:45:00​
TRUE​
2023-02-24 20:50:00​
TRUE​
2023-02-24 20:55:00​
TRUE​
2023-02-24 21:00:00​
TRUE​
2023-02-24 21:05:00​
TRUE​
2023-02-24 21:10:00​
TRUE​
2023-02-24 21:15:00​
TRUE​
2023-02-24 21:20:00​
TRUE​
2023-02-24 21:25:00​
TRUE​
2023-02-24 21:30:00​
TRUE​
2023-02-24 21:35:00​
TRUE​
2023-02-24 21:40:00​
TRUE​
2023-02-24 21:45:00​
TRUE​
2023-02-24 21:50:00​
TRUE​
2023-02-24 21:55:00​
TRUE​
2023-02-24 22:00:00​
TRUE​
2023-02-24 22:05:00​
TRUE​
2023-02-24 22:10:00​
TRUE​
2023-02-24 22:15:00​
TRUE​
2023-02-24 22:20:00​
TRUE​
2023-02-24 22:25:00​
TRUE​
2023-02-24 22:30:00​
TRUE​
2023-02-24 22:35:00​
TRUE​
2023-02-24 22:40:00​
TRUE​
2023-02-24 22:45:00​
TRUE​
2023-02-24 22:50:00​
TRUE​
2023-02-24 22:55:00​
TRUE​
2023-02-24 23:00:00​
TRUE​
2023-02-24 23:05:00​
TRUE​
2023-02-24 23:10:00​
TRUE​
2023-02-24 23:15:00​
TRUE​
2023-02-24 23:20:00​
TRUE​
2023-02-24 23:25:00​
TRUE​
2023-02-24 23:30:00​
TRUE​
2023-02-24 23:35:00​
TRUE​
2023-02-24 23:40:00​
TRUE​
2023-02-24 23:45:00​
TRUE​
2023-02-24 23:50:00​
TRUE​
2023-02-24 23:55:00​
TRUE​
2023-02-25 00:00:00​
TRUE​
2023-02-25 00:05:00​
TRUE​
2023-02-25 00:10:00​
TRUE​
2023-02-25 00:15:00​
TRUE​
2023-02-25 00:20:00​
TRUE​
2023-02-25 00:25:00​
TRUE​
2023-02-25 00:30:00​
TRUE​
2023-02-25 00:35:00​
TRUE​
2023-02-25 00:40:00​
TRUE​
2023-02-25 00:45:00​
TRUE​
2023-02-25 00:50:00​
TRUE​
2023-02-25 00:55:00​
TRUE​
2023-02-25 01:00:00​
TRUE​
2023-02-25 01:05:00​
TRUE​
2023-02-25 01:10:00​
TRUE​
2023-02-25 01:15:00​
TRUE​
2023-02-25 01:20:00​
TRUE​
2023-02-25 01:25:00​
TRUE​
2023-02-25 01:30:00​
TRUE​
2023-02-25 01:35:00​
TRUE​
2023-02-25 01:40:00​
TRUE​
2023-02-25 01:45:00​
TRUE​
2023-02-25 01:50:00​
TRUE​
2023-02-25 01:55:00​
TRUE​
2023-02-25 02:00:00​
TRUE​
2023-02-25 02:05:00​
TRUE​
2023-02-25 02:10:00​
TRUE​
2023-02-25 02:15:00​
TRUE​
2023-02-25 02:20:00​
TRUE​
2023-02-25 02:25:00​
TRUE​
2023-02-25 02:30:00​
TRUE​
2023-02-25 02:35:00​
TRUE​
2023-02-25 02:40:00​
TRUE​
2023-02-25 02:45:00​
TRUE​
2023-02-25 02:50:00​
TRUE​
2023-02-25 02:55:00​
TRUE​
2023-02-25 03:00:00​
TRUE​
2023-02-25 03:05:00​
TRUE​
2023-02-25 03:10:00​
TRUE​
2023-02-25 03:15:00​
TRUE​
2023-02-25 03:20:00​
TRUE​
2023-02-25 03:25:00​
TRUE​
2023-02-25 03:30:00​
TRUE​
2023-02-25 03:35:00​
TRUE​
2023-02-25 03:40:00​
TRUE​
2023-02-25 03:45:00​
TRUE​
2023-02-25 03:50:00​
TRUE​
2023-02-25 03:55:00​
TRUE​
2023-02-25 04:00:00​
TRUE​
2023-02-25 04:05:00​
TRUE​
2023-02-25 04:10:00​
TRUE​
2023-02-25 04:15:00​
TRUE​
2023-02-25 04:20:00​
TRUE​
2023-02-25 04:25:00​
TRUE​
2023-02-25 04:30:00​
TRUE​
2023-02-25 04:35:00​
TRUE​
2023-02-25 04:40:00​
TRUE​
2023-02-25 04:45:00​
TRUE​
2023-02-25 04:50:00​
TRUE​
2023-02-25 04:55:00​
TRUE​
2023-02-25 05:00:00​
TRUE​
2023-02-25 05:05:00​
TRUE​
2023-02-25 05:10:00​
TRUE​
2023-02-25 05:15:00​
TRUE​
2023-02-25 05:20:00​
TRUE​
2023-02-25 05:25:00​
TRUE​
2023-02-25 05:30:00​
TRUE​
2023-02-25 05:35:00​
TRUE​
2023-02-25 05:40:00​
TRUE​
2023-02-25 05:45:00​
TRUE​
2023-02-25 05:50:00​
TRUE​
2023-02-25 05:55:00​
TRUE​
2023-02-25 06:00:00​
TRUE​
2023-02-25 06:05:00​
TRUE​
2023-02-25 06:10:00​
TRUE​
2023-02-25 06:15:00​
TRUE​
2023-02-25 06:20:00​
TRUE​
2023-02-25 06:25:00​
TRUE​
2023-02-25 06:30:00​
TRUE​
2023-02-25 06:35:00​
TRUE​
2023-02-25 06:40:00​
TRUE​
2023-02-25 06:45:00​
TRUE​
2023-02-25 06:50:00​
TRUE​
2023-02-25 06:55:00​
TRUE​
2023-02-25 07:00:00​
TRUE​
2023-02-25 07:05:00​
TRUE​
2023-02-25 07:10:00​
TRUE​
2023-02-25 07:15:00​
TRUE​
2023-02-25 07:20:00​
TRUE​
2023-02-25 07:25:00​
TRUE​
2023-02-25 07:30:00​
TRUE​
2023-02-25 07:35:00​
TRUE​
2023-02-25 07:40:00​
TRUE​
2023-02-25 07:45:00​
TRUE​
2023-02-25 07:50:00​
TRUE​
2023-02-25 07:55:00​
TRUE​
2023-02-25 08:00:00​
TRUE​
2023-02-25 08:05:00​
TRUE​
2023-02-25 08:10:00​
TRUE​
2023-02-25 08:15:00​
TRUE​
2023-02-25 08:20:00​
TRUE​
2023-02-25 08:25:00​
TRUE​
2023-02-25 08:30:00​
TRUE​
2023-02-25 08:35:00​
TRUE​
2023-02-25 08:40:00​
TRUE​
2023-02-25 08:45:00​
TRUE​
2023-02-25 08:50:00​
TRUE​
2023-02-25 08:55:00​
TRUE​
2023-02-25 09:00:00​
TRUE​
2023-02-25 09:05:00​
TRUE​
2023-02-25 09:10:00​
TRUE​
2023-02-25 09:15:00​
TRUE​
2023-02-25 09:20:00​
TRUE​
2023-02-25 09:25:00​
TRUE​
2023-02-25 09:30:00​
TRUE​
2023-02-25 09:35:00​
TRUE​
2023-02-25 09:40:00​
TRUE​
2023-02-25 09:45:00​
TRUE​
2023-02-25 09:50:00​
TRUE​
2023-02-25 09:55:00​
TRUE​
2023-02-25 10:00:00​
TRUE​
2023-02-25 10:05:00​
TRUE​
2023-02-25 10:10:00​
TRUE​
2023-02-25 10:15:00​
TRUE​
2023-02-25 10:20:00​
TRUE​
2023-02-25 10:25:00​
TRUE​
2023-02-25 10:30:00​
TRUE​
2023-02-25 10:35:00​
TRUE​
2023-02-25 10:40:00​
TRUE​
2023-02-25 10:45:00​
TRUE​
2023-02-25 10:50:00​
TRUE​
2023-02-25 10:55:00​
TRUE​
2023-02-25 11:00:00​
TRUE​
2023-02-25 11:05:00​
TRUE​
2023-02-25 11:10:00​
TRUE​
2023-02-25 11:15:00​
TRUE​
2023-02-25 11:20:00​
TRUE​
2023-02-25 11:25:00​
TRUE​
2023-02-25 11:30:00​
TRUE​
2023-02-25 11:35:00​
TRUE​
2023-02-25 11:40:00​
TRUE​
2023-02-25 11:45:00​
TRUE​
2023-02-25 11:50:00​
TRUE​
2023-02-25 11:55:00​
TRUE​
2023-02-25 12:00:00​
TRUE​
2023-02-25 12:05:00​
TRUE​
2023-02-25 12:10:00​
TRUE​
2023-02-25 12:15:00​
TRUE​
2023-02-25 12:20:00​
TRUE​
2023-02-25 12:25:00​
TRUE​
2023-02-25 12:30:00​
TRUE​
2023-02-25 12:35:00​
TRUE​
2023-02-25 12:40:00​
TRUE​
2023-02-25 12:45:00​
TRUE​
2023-02-25 12:50:00​
TRUE​
2023-02-25 12:55:00​
TRUE​
2023-02-25 13:00:00​
TRUE​
2023-02-25 13:05:00​
TRUE​
2023-02-25 13:10:00​
TRUE​
2023-02-25 13:15:00​
TRUE​
2023-02-25 13:20:00​
TRUE​
2023-02-25 13:25:00​
TRUE​
2023-02-25 13:30:00​
TRUE​
2023-02-25 13:35:00​
TRUE​
2023-02-25 13:40:00​
TRUE​
2023-02-25 13:45:00​
TRUE​
2023-02-25 13:50:00​
TRUE​
2023-02-25 13:55:00​
TRUE​
2023-02-25 14:00:00​
TRUE​
2023-02-25 14:05:00​
TRUE​
2023-02-25 14:10:00​
TRUE​
2023-02-25 14:15:00​
TRUE​
2023-02-25 14:20:00​
TRUE​
2023-02-25 14:25:00​
TRUE​
2023-02-25 14:30:00​
TRUE​
2023-02-25 14:35:00​
TRUE​
2023-02-25 14:40:00​
TRUE​
2023-02-25 14:45:00​
TRUE​
2023-02-25 14:50:00​
TRUE​
2023-02-25 14:55:00​
TRUE​
2023-02-25 15:00:00​
TRUE​
2023-02-25 15:05:00​
TRUE​
2023-02-25 15:10:00​
TRUE​
2023-02-25 15:15:00​
TRUE​
2023-02-25 15:20:00​
TRUE​
2023-02-25 15:25:00​
TRUE​
2023-02-25 15:30:00​
TRUE​
2023-02-25 15:35:00​
TRUE​
2023-02-25 15:40:00​
TRUE​
2023-02-25 15:45:00​
TRUE​
2023-02-25 15:50:00​
TRUE​
2023-02-25 15:55:00​
TRUE​
2023-02-25 16:00:00​
TRUE​
2023-02-25 16:05:00​
TRUE​
2023-02-25 16:10:00​
TRUE​
2023-02-25 16:15:00​
TRUE​
2023-02-25 16:20:00​
TRUE​
2023-02-25 16:25:00​
TRUE​
2023-02-25 16:30:00​
TRUE​
2023-02-25 16:35:00​
TRUE​
2023-02-25 16:40:00​
TRUE​
2023-02-25 16:45:00​
TRUE​
2023-02-25 16:50:00​
TRUE​
2023-02-25 16:55:00​
TRUE​
2023-02-25 17:00:00​
TRUE​
2023-02-25 17:05:00​
TRUE​
2023-02-25 17:10:00​
TRUE​
2023-02-25 17:15:00​
TRUE​
2023-02-25 17:20:00​
FALSE​
2023-02-25 17:25:00​
FALSE​
2023-02-25 17:30:00​
FALSE​
2023-02-25 17:35:00​
FALSE​
2023-02-25 17:40:00​
FALSE​
2023-02-25 17:45:00​
FALSE​
2023-02-25 17:50:00​
FALSE​
2023-02-25 17:55:00​
TRUE​
2023-02-25 18:00:00​
TRUE​
2023-02-25 18:05:00​
TRUE​
2023-02-25 18:10:00​
TRUE​
2023-02-25 18:15:00​
TRUE​
2023-02-25 18:20:00​
TRUE​
2023-02-25 18:25:00​
TRUE​
2023-02-25 18:30:00​
TRUE​
2023-02-25 18:35:00​
TRUE​
2023-02-25 18:40:00​
TRUE​
2023-02-25 18:45:00​
TRUE​
2023-02-25 18:50:00​
TRUE​
2023-02-25 18:55:00​
TRUE​
2023-02-25 19:00:00​
TRUE​
2023-02-25 19:05:00​
TRUE​
2023-02-25 19:10:00​
TRUE​
2023-02-25 19:15:00​
TRUE​
2023-02-25 19:20:00​
TRUE​
2023-02-25 19:25:00​
TRUE​
2023-02-25 19:30:00​
TRUE​
2023-02-25 19:35:00​
TRUE​
2023-02-25 19:40:00​
TRUE​
2023-02-25 19:45:00​
TRUE​
2023-02-25 19:50:00​
TRUE​
2023-02-25 19:55:00​
TRUE​
2023-02-25 20:00:00​
TRUE​
2023-02-25 20:05:00​
TRUE​
2023-02-25 20:10:00​
TRUE​
2023-02-25 20:15:00​
TRUE​
2023-02-25 20:20:00​
TRUE​
2023-02-25 20:25:00​
TRUE​
2023-02-25 20:30:00​
TRUE​
2023-02-25 20:35:00​
TRUE​
2023-02-25 20:40:00​
TRUE​
2023-02-25 20:45:00​
TRUE​
2023-02-25 20:50:00​
TRUE​
2023-02-25 20:55:00​
TRUE​
2023-02-25 21:00:00​
TRUE​
2023-02-25 21:05:00​
TRUE​
2023-02-25 21:10:00​
TRUE​
2023-02-25 21:15:00​
TRUE​
2023-02-25 21:20:00​
TRUE​
2023-02-25 21:25:00​
TRUE​
2023-02-25 21:30:00​
TRUE​
2023-02-25 21:35:00​
TRUE​
2023-02-25 21:40:00​
TRUE​
2023-02-25 21:45:00​
TRUE​
2023-02-25 21:50:00​
TRUE​
2023-02-25 21:55:00​
TRUE​
2023-02-25 22:00:00​
TRUE​
2023-02-25 22:05:00​
TRUE​
2023-02-25 22:10:00​
TRUE​
2023-02-25 22:15:00​
TRUE​
2023-02-25 22:20:00​
TRUE​
2023-02-25 22:25:00​
TRUE​
2023-02-25 22:30:00​
TRUE​
2023-02-25 22:35:00​
TRUE​
2023-02-25 22:40:00​
TRUE​
2023-02-25 22:45:00​
TRUE​
2023-02-25 22:50:00​
TRUE​
2023-02-25 22:55:00​
TRUE​
2023-02-25 23:00:00​
TRUE​
2023-02-25 23:05:00​
TRUE​
2023-02-25 23:10:00​
TRUE​
2023-02-25 23:15:00​
TRUE​
2023-02-25 23:20:00​
TRUE​
2023-02-25 23:25:00​
TRUE​
2023-02-25 23:30:00​
TRUE​
2023-02-25 23:35:00​
TRUE​
2023-02-25 23:40:00​
TRUE​
2023-02-25 23:45:00​
TRUE​
2023-02-25 23:50:00​
TRUE​
2023-02-25 23:55:00​
TRUE​
2023-02-26 00:00:00​
TRUE​
2023-02-26 00:05:00​
FALSE​
2023-02-26 00:10:00​
FALSE​
2023-02-26 00:15:00​
FALSE​
2023-02-26 00:20:00​
FALSE​
2023-02-26 00:25:00​
FALSE​
2023-02-26 00:30:00​
FALSE​
2023-02-26 00:35:00​
FALSE​
2023-02-26 00:40:00​
FALSE​
2023-02-26 00:45:00​
FALSE​
2023-02-26 00:50:00​
TRUE​
2023-02-26 00:55:00​
TRUE​
2023-02-26 01:00:00​
TRUE​
2023-02-26 01:05:00​
TRUE​
2023-02-26 01:10:00​
TRUE​
2023-02-26 01:15:00​
TRUE​
2023-02-26 01:20:00​
TRUE​
2023-02-26 01:25:00​
TRUE​
2023-02-26 01:30:00​
TRUE​
2023-02-26 01:35:00​
TRUE​
2023-02-26 01:40:00​
TRUE​
2023-02-26 01:45:00​
TRUE​
2023-02-26 01:50:00​
TRUE​
2023-02-26 01:55:00​
TRUE​
2023-02-26 02:00:00​
TRUE​
2023-02-26 02:05:00​
TRUE​
2023-02-26 02:10:00​
TRUE​
2023-02-26 02:15:00​
TRUE​
2023-02-26 02:20:00​
TRUE​
2023-02-26 02:25:00​
TRUE​
2023-02-26 02:30:00​
TRUE​
2023-02-26 02:35:00​
TRUE​
2023-02-26 02:40:00​
TRUE​
2023-02-26 02:45:00​
TRUE​
2023-02-26 02:50:00​
TRUE​
2023-02-26 02:55:00​
TRUE​
2023-02-26 03:00:00​
TRUE​
2023-02-26 03:05:00​
TRUE​
2023-02-26 03:10:00​
TRUE​
2023-02-26 03:15:00​
TRUE​
2023-02-26 03:20:00​
TRUE​
2023-02-26 03:25:00​
TRUE​
2023-02-26 03:30:00​
TRUE​
2023-02-26 03:35:00​
TRUE​
2023-02-26 03:40:00​
TRUE​
2023-02-26 03:45:00​
TRUE​
2023-02-26 03:50:00​
TRUE​
2023-02-26 03:55:00​
TRUE​
2023-02-26 04:00:00​
TRUE​
2023-02-26 04:05:00​
TRUE​
2023-02-26 04:10:00​
TRUE​
2023-02-26 04:15:00​
TRUE​
2023-02-26 04:20:00​
TRUE​
2023-02-26 04:25:00​
TRUE​
2023-02-26 04:30:00​
TRUE​
2023-02-26 04:35:00​
TRUE​
2023-02-26 04:40:00​
TRUE​
2023-02-26 04:45:00​
TRUE​
2023-02-26 04:50:00​
TRUE​
2023-02-26 04:55:00​
TRUE​
2023-02-26 05:00:00​
TRUE​
2023-02-26 05:05:00​
TRUE​
2023-02-26 05:10:00​
TRUE​
2023-02-26 05:15:00​
TRUE​
2023-02-26 05:20:00​
TRUE​
2023-02-26 05:25:00​
TRUE​
2023-02-26 05:30:00​
TRUE​
2023-02-26 05:35:00​
TRUE​
2023-02-26 05:40:00​
TRUE​
2023-02-26 05:45:00​
TRUE​
2023-02-26 05:50:00​
TRUE​
2023-02-26 05:55:00​
TRUE​
2023-02-26 06:00:00​
TRUE​
2023-02-26 06:05:00​
TRUE​
2023-02-26 06:10:00​
TRUE​
2023-02-26 06:15:00​
TRUE​
2023-02-26 06:20:00​
TRUE​
2023-02-26 06:25:00​
TRUE​
2023-02-26 06:30:00​
TRUE​
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Status
Not open for further replies.

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

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