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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Radio Buttons to work, that are inserted via AutoText 0
Creating Multi Level list using Header Style 1
Time calculations over 24hrs 8
Convertin hours into days, hours and minutes 6
How To Have A Cell Be Blank If... 2
Time Calculation 5
Networkdays equivalent for minutes 2
Question on Format in Hour & Minute 3

Top