I'm using the formula shown below in cell K5. If I drag the formula down it works correctly except cell K6 which shows 23:15 rather than 00:45. Can anyone assist so that the correct values are shown?
Please note that the values are based on hours and minutes which are formatted as [hh]:mm
Ideally I would like to show a reduction with a minus sign but this is not essential as I can use some conditional formatting to get around this.
Column E Column H Column K (Result)
842:31 832:25 10:06
501:51 502:36 23:15 (Incorrect)
832:25 502:36 329:49
502:36 501:51 00:45
Thanks in advance.
Please note that the values are based on hours and minutes which are formatted as [hh]:mm
Ideally I would like to show a reduction with a minus sign but this is not essential as I can use some conditional formatting to get around this.
Column E Column H Column K (Result)
842:31 832:25 10:06
501:51 502:36 23:15 (Incorrect)
832:25 502:36 329:49
502:36 501:51 00:45
Thanks in advance.
Code:
=IF(E5<H5,E5-H5+(E5<H5),E5-H5)
Code: