Excelexcel86
Board Regular
- Joined
- Feb 28, 2023
- Messages
- 99
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi guys quick question how do I calculate time but only first 6 hours from two dates like so
02/03/2023 10:30 02/03/2023 15:30.
Obviously if I just minus the two cells I get 5 hours but I need it to stop calculating anything after 12:00 on the same day so it should be 1.30 hours
Any help be much appreciated
02/03/2023 10:30 02/03/2023 15:30.
Obviously if I just minus the two cells I get 5 hours but I need it to stop calculating anything after 12:00 on the same day so it should be 1.30 hours
Any help be much appreciated