Excel Copying and pasting Time error

[ZThaButcher]

Okay, So I have a document I have been building for a schedule.
I have a control sheet that has all the control data, then Base Data which has the same data plus different times for different time zones.
Then I have other sheets that have the same data but are related to their time zone.
It takes the PST Time and then converts it via the following code =CellforPSTTime+(1/24)
I have a Visual Basic Code that copies this and pastes it as a value.
Well for some reason with Times ranging from 00:00 - 2:00 AM it adds a date as seen in the screenshot below.
How can I get it to paste without the date? It is driving me crazy.
If it wouldn't mess up the chart to the right that would be fine but when it has a date it just spans it across the entire schedule as seen in the screenshot.

 

[Alex Blakenburg]

It depends on how you are using the times generated by your original formula in its orignal location (source sheet)
The copy is not creating the date but the formula is.
Depending on the answer you could change your formula to be

=MOD(CellforPSTTime+(1/24), 1)

If you want the code modified, it will need to need to peform a similar calculation and you will need to clarify your to and from range.
Copying BA3:BE150 to AG3 which will expand to the same no of rows and columns as in the copy from range, does not seem to make any sense in terms of the image you provided not to mention highlighting cells in the column AK.

 

[ZThaButcher]

Thank you Alex! That code actually fixed my issue.

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.