Date Time - Change Time to Text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RodBoggy - 17 Jan 2006 19:34 GMT

I require to write a Macro for Excel that will change a Time to Text.
Such as: '26-Apr -06 08:00' to read '26-Apr-06 Pd 1' instead of Time
(08:00 is period 1 of day)
or '26-Apr -06 08:45' to read '26-Apr -06 Pd 2' instead of Time.
(08:00 is period 2 of day)

I have 10 periods in the day. Is it possible to do this and for a
complete page of scheduled date/Times. It is really a 'Format Column'
type Macro that I require.

Many thanks if any help is possible.

Signature

RodBoggy

Reply to this Message

Dave Peterson - 17 Jan 2006 20:32 GMT

I think you're going to have to restate your problem.

Sometimes you have a space after the month--sometimes not.

And 8:00 is period 1 and period 2.

In fact, I think you'll have to give the rules concerning all the time periods.

And is there a reason you can't use a helper cell and a worksheet formula?

> I require to write a Macro for Excel that will change a Time to Text.
> Such as: '26-Apr -06 08:00' to read '26-Apr-06 Pd 1' instead of Time
[quoted text clipped - 13 lines]
> RodBoggy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30570
> View this thread: http://www.excelforum.com/showthread.php?threadid=502182

Signature

Dave Peterson

Reply to this Message