Spreadsheet: 880431d1728142674-how-to-get-results-in-minutes-cell-n-at-glance-from-sheet-1-to-sheet-2-forum-test
Sheet: Sheet1

seq | number | name | DATE | day | month | START | END | week | time | floor | assigned | Service |  | END
1 | 2000 | DOE, [NAME] | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 08:00 AM | 1 | 800 | (646) special | 15
2 | 2008 | DOE, [NAME] | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 08:45 AM | 1 | ONLY | (912) non special | 15
3 | 533 | DOE, [NAME] | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 09:00 AM | 2 | 956 | (638) specific | 55
4 | 35000 | PARIS, ARTHUR | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 09:55 AM | 1 | ONLY | (639) non | 15
5 | 15 | FLORIDA, ANA | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 10:10 AM | 2 | 75735 | (650) crucial | 60
6 | 32158 | WASHINGTON, TED | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 08:15 AM | 1 | 232869 | (844) added | 15
7 | 2000 | DOE, [NAME] | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 11:10 AM | 1 | ONLY | (950) adquired | 15
8 | 2008 | DOE, [NAME] | 2024-08-14 00:00:00 |  |  | 2024-08-11 00:00:00 | 2024-08-17 00:00:00 | 33 | 11:25 AM | 1 | 26556 | (952) do not use | 55
9 | 32158 | WASHINGTON, TED | 2024-08-15 00:00:00 |  |  | 2024-08-11 00:00:00 | 2024-08-17 00:00:00 | 33 | 12:20 PM | 2 | ONLY | (911) non special | 15
10 | 2008 | DOE, [NAME] | 2024-08-15 00:00:00 |  |  | 2024-08-11 00:00:00 | 2024-08-17 00:00:00 | 33 | 12:35 PM | 1 | 232869 | (646) special | 60
11 | 32158 | WASHINGTON, TED | 2024-08-15 00:00:00 |  |  | 2024-08-11 00:00:00 | 2024-08-17 00:00:00 | 33 | 08:30 AM | 1 | 20 | (912) non special | 15
12 | 2008 | DOE, [NAME] | 2024-08-15 00:00:00 |  |  | 2024-08-11 00:00:00 | 2024-08-17 00:00:00 | 33 | 01:35 PM | 2 | ONLY | (638) specific | 15
13 | 2000 | DOE, [NAME] | 2024-08-15 00:00:00 |  |  | 2024-08-11 00:00:00 | 2024-08-17 00:00:00 | 33 | 01:50 PM | 1 | SUPLEMENTARY LAST | (639) non | 55
14 | 32158 | WASHINGTON, TED | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 02:45 PM | 1 | ONLY | (650) crucial | 15
15 | 32158 | WASHINGTON, TED | 2024-09-16 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 03:00 PM | 1 | SUPLEMENTARY LAST | (844) added | 60
16 | 533 | DOE, [NAME] | 2024-09-17 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 08:00 AM | 2 | 42504 | (950) adquired | 15
17 | 35000 | PARIS, ARTHUR | 2024-09-17 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 08:45 AM | 1 | ONLY | (952) do not use | 15
18 | 32158 | WASHINGTON, TED | 2024-09-17 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 09:00 AM | 1 | 42504 | (911) non special | 55
19 | 533 | DOE, [NAME] | 2024-09-17 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 09:55 AM | 2 | ONLY | (650) crucial | 15
20 | 533 | DOE, [NAME] | 2024-09-17 00:00:00 |  |  | 2024-09-15 00:00:00 | 2024-09-21 00:00:00 | 38 | 10:10 AM | 1 | 42504 | (911) non special | 60
 |  | THE FORMULA GOES ON SHEET 2…
 |  | AND WILL GIVE THE RESULT IN MINUTES FROM
 |  | THIS SHEET, COLUNM N (green)