WOW
Thanks for the help. There are far greater minds at work here then my miniscule nugget! Unforunately I still cant get it to work.
Putting 39:55 in Cell A1 and using the Llademos method gives me an answer of 384:00
same again using the Jhieminga method (remembering to adjust all references to cell A1) gives an error message. Returning to the formula the cursor is placed "=IF((MINUTE(I269)> 30)
here ;(DAY(I269)+TIME(HOUR(I269)+1;0;0));(DAY(I269)+TIME(HOUR(I26 9);0;0)))
All cells formatted at [hh]:mm
Sorry for putting this on you, I know you like a challenge
CBK