Ediy Date & Time to change Time to Text

  • Thread starter Thread starter RodBoggy
  • Start date Start date
R

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
 
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
 
Back
Top