Excel International Versions
Capt BK
Your problem with Jhieminga's formula may be one of internationalisation.
He is working with a version of Excel which uses commas as the decimal separator in the continental fashion eg: a half is 0,5 not 0.5.
The consequence is that the formula separator in Excel becomes a semi-colon. To resolve this problem change the semi-colons to commas:
"=IF((MINUTE(I269)> 30),(DAY(I269)+TIME(HOUR(I269)+1),0),0))),(DAY(I269)+TIME(HOUR(I269)),0),0)))"
Hope this helps
EG