Joneye
Well-known Member
- Joined
- May 28, 2010
- Messages
- 777
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
Here's my out put data, usually i'll over complicat things in formulas, asking here here what alternative methods are out there for countying time, date, day and month in data.
My standard approach would be, Insert column after A with =text(A1,"MMM") giving me Jan - Dec.
Where i've issues is
1. Finding a foumla to subtracting time
2. Not being able to calculate the day and total hour
3. Is my approach correct
My standard approach would be, Insert column after A with =text(A1,"MMM") giving me Jan - Dec.
Where i've issues is
1. Finding a foumla to subtracting time
2. Not being able to calculate the day and total hour
3. Is my approach correct
Start Date | Start Time | Stop Date | Stop Time | Project | |
2022-02-28 | 08:30:00 | 2022-02-28 | 09:00:00 | | Admin |
2022-04-28 | 09:00:00 | 2022-02-28 | 09:15:00 | | Admin |
2022-04-28 | 09:15:00 | 2022-02-28 | 09:30:00 | | Paper Work |
2022-02-28 | 09:30:00 | 2022-02-28 | 10:00:00 | | Paper Work |
2022-02-28 | 10:00:00 | 2022-02-28 | 11:00:00 | | Calls |
2022-02-28 | 11:00:00 | 2022-02-28 | 12:00:00 | | Meeting |
2022-03-28 | 12:00:00 | 2022-02-28 | 13:00:00 | | Meeting |
2022-02-27 | 13:00:00 | 2022-02-28 | 14:00:00 | | Calls |