de-celling hours and minutes

D

DaveB

Thanks for your help, it has worked partially ( :rolleyes: actually, the
original question has worked fully).

I have a calculated cell that shows time e.g. b1+c1 = 4:40, that is no
problem I now need to copy/paste special link into "sheet 2" and it
comes up with *number error, ideas appreciated.
 
Top