Apr 12 2022 02:03 PM
I'm trying to create a formula where if the end time is later than 4pm the split time is 4pm, but if it is earlier than 4pm the split time is the end time. However it just shows up as =C6 instead of the actual time entry in the cell C6.
=IF(C6="","",IF(C6>(--"4:00 PM"),"4:00 PM","=C6"))
Any help is appreciated
Apr 12 2022 02:17 PM
Solution=IF(C5="","",IF(C5>$D$1,$D$1,C5))
You can try this formula in the attached file. It seems to work in my sheet if i correctly understand what you want to do. You can dynamically enter the split time in cell D1.
Apr 12 2022 02:17 PM
Solution=IF(C5="","",IF(C5>$D$1,$D$1,C5))
You can try this formula in the attached file. It seems to work in my sheet if i correctly understand what you want to do. You can dynamically enter the split time in cell D1.