Formulas

[Ron]

I would like a formula to get only the start time of a task and not the whole
date time stamp.

I'm not sure how to get this info.

Help!

Thanks

 

[John]

I would like a formula to get only the start time of a task and not the whole
date time stamp.

I'm not sure how to get this info.

Help!

Thanks

Ron,
The following formula will do what you need (assuming the Start field is
the date for which you want the time only.
mid([Start],instr(1,[Start]," ")+1)

John
Project MVP

 

[Jan De Messemaeker]

Hi,

You can use Timevalue or if uyou want more control on the formatting, Hour
and Minute functions
HTH