Ediy Date & Time to change Time to Text

[RodBoggy]

My apologies for the first unclear posting, I should not have done i
immediately after a long day at work.

I need to write a Macro for an Excel spreadsheet that will change
Time to Text.

Such as: *'26-Apr-06 08:00' *to read *'26-Apr-06 Pd 1' *instead of Tim
(Pd1 instead of 08:00)
or as an example
*'26-Apr-06 08:45' *to read *'26-Apr-06 Pd 2' *instead of Time (Pd
instead of 08:45)

I have 10 periods in the day, Once I understand how to do it for On
Date/Time I can hopefully do it for the others. Is it possible to d
this? and for a complete page of scheduled Date/Times. The Date an
Time are in One column so I need to Edit or Format the Column, tellin
the macro which Pd to substitute for each of the Ten Period Times.

Many thanks if any help is possible

 

[Pete_UK]

Are your 10 values of Pd equally spaced through the day (i.e. = 2.4 hr
periods), or do they have variable times allocated to them? If the
first answer is correct, then a single formula (copied down) can do
this - if the second case is true, you will need to list your start
time values and periods in a small table then a Vlookup formula will
apply.

Please re-post with details of your periods.

Pete