redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi al
Can somebody help with a formula that will check the time difference between two times (in column E & G) and if under 6hrs then deduct 15mins time and if => 6hrs then deduct 30mins
I currently use this formula (in column I) to calculate the time and deduct 30mins regardless
=IF(ISBLANK(H357),"",IF(H357="N",G357-E357,8/24)-(1/48))
So with above example the correct result in column I should be 05:44 as the time difference is under 6hrs and only 15mins should be deducted. not 30
TIA
Can somebody help with a formula that will check the time difference between two times (in column E & G) and if under 6hrs then deduct 15mins time and if => 6hrs then deduct 30mins
I currently use this formula (in column I) to calculate the time and deduct 30mins regardless
=IF(ISBLANK(H357),"",IF(H357="N",G357-E357,8/24)-(1/48))
E | F | G | H | I |
---|---|---|---|---|
26/03/2020 07:15:00 | 26/03/2020 13:14:00 | N | 05:29 |
So with above example the correct result in column I should be 05:44 as the time difference is under 6hrs and only 15mins should be deducted. not 30
TIA