Retain color/format from ws1 to ws2

I am pretty new to Excel and currently have two problems that I need help with. I have linked several cells from worksheet 1 onto worksheet 2 but the background colors from worksheet 1 did not come over with the data. Is there any way to bring the format and background colors over from one sheet to another?

Also, I am doing a payroll worksheet that subtracts In time from Out time minus lunch to get number of hours worked. I am using military time so the subtraction will work but I am calculating hrs worked based on tenths of an hour instead of sixths of an hour in order to get the correct hours worked. Example: It should be: 05:30am to 1:30pm minus .30 for lunch = 7.50 hrs worked.
Instead I am using the following calculation 13.50-05.50-.50 to get 7.50. I am sure there is a better way to do this but I don't know how. Any help will be appreciated.

Hi,

1. Linking cells, by which I presume you mean by formula - e.g. =Sheet1!A1 will not use the formats from the precedent sheet. You can only bring formats across by copying the cells and using the Paste Special Formats.

2. You could use:

Please Login or Register  to view this content.

where A1 is the first time and B1 the second (later) time. The IF test is to allow for times which straddle 12:00 midnight.

HTH

Another option is

=(B1-A1-"0:30"+(B1<A1))*24

and format the result as 0.00