Referencing Time from another worksheet

[Coors]

I have attached an excel file as an example of my troubles. Basically, I have a file with two worksheets. Sheet 1 "PB Inputs" has a time value as "6:00AM" for example, and I am trying to have that value go to Sheet 2 "Machine". Every time on the 'Machine" sheet when I put B2= ('PB Inputs'!D3:E4) I get #Value!. WHY?????? ?????
I figured this would be simple, but I guessed wrong.

Thanks

[arthurbr]

Why? because you are using merged cells. Except for formatting purposes for display only you should NOT use them !
Unmerge your cells, and refer to D only to link the sheets.
If you want some nicer formattong try " Center across selection"

[Coors]

Thanks, I guess I have never ran across that problem before. For example, I am using merged cells as a reference on the same worksheet and it work fine , but not when I am jumping from sheet to sheet .

Well, I guess I am sorry for the stupid question, but thanks for responding so quick.

Thanks again