Separate Date and Time

[neesie214]

Is it possible to separate date and time in different fields? For example, I
would like to create four separate fields: Start Date, Start Time, Finish
Date and Finish Time. Right now the date and time are combined in the "Start"
and "Finish" fields. When I try to format them differently, the changes
affect all the fields. Please help! Thanks.

 

[JulieS]

Hello neesie214,

Insert text fields (Text1, Text2 etc) and add a custom formulas:

To show Start Date: Format([Start], "mm/dd/yy")
To show Start time: Format ([Start], "hh:mm")

Repeat for Finish date/time but substitute [Finish] for [Start]

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[neesie214]

Thank you - that does help, sort of. How do I display the time in
non-military format with AM and PM?

Hello neesie214,

Insert text fields (Text1, Text2 etc) and add a custom formulas:

To show Start Date: Format([Start], "mm/dd/yy")
To show Start time: Format ([Start], "hh:mm")

Repeat for Finish date/time but substitute [Finish] for [Start]

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

Is it possible to separate date and time in different fields? For
example, I
would like to create four separate fields: Start Date, Start Time,
Finish
Date and Finish Time. Right now the date and time are combined in
the "Start"
and "Finish" fields. When I try to format them differently, the
changes
affect all the fields. Please help! Thanks.

 

[neesie214]

Never mind - figured this out by looking at the custom date formulas in
Excel. This was extremely helpful! Thank you!

Thank you - that does help, sort of. How do I display the time in
non-military format with AM and PM?

Hello neesie214,

Insert text fields (Text1, Text2 etc) and add a custom formulas:

To show Start Date: Format([Start], "mm/dd/yy")
To show Start time: Format ([Start], "hh:mm")

Repeat for Finish date/time but substitute [Finish] for [Start]

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

Is it possible to separate date and time in different fields? For
example, I
would like to create four separate fields: Start Date, Start Time,
Finish
Date and Finish Time. Right now the date and time are combined in
the "Start"
and "Finish" fields. When I try to format them differently, the
changes
affect all the fields. Please help! Thanks.

 

[JulieS]

You're welcome. Glad to have helped and thanks for the feedback.

Julie

Never mind - figured this out by looking at the custom date
formulas in
Excel. This was extremely helpful! Thank you!

Thank you - that does help, sort of. How do I display the time in
non-military format with AM and PM?

Hello neesie214,

Insert text fields (Text1, Text2 etc) and add a custom
formulas:

To show Start Date: Format([Start], "mm/dd/yy")
To show Start time: Format ([Start], "hh:mm")

Repeat for Finish date/time but substitute [Finish] for [Start]

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

message
Is it possible to separate date and time in different fields?
For
example, I
would like to create four separate fields: Start Date, Start
Time,
Finish
Date and Finish Time. Right now the date and time are
combined in
the "Start"
and "Finish" fields. When I try to format them differently,
the
changes
affect all the fields. Please help! Thanks.