I have a space limitation I am working with and have no additional colum
room, and the data needs to be visable for our clerical input specialist...
Thanks for the suggestion. I will log for future considerations as it may
help in future versions.

Thanks

"jopla" wrote:

Can you guys help me with a problem? On an anniversary date, I want to add
vacation days to an individual's vacation accrued cell. How can I do that?

"Ben McBen" wrote:

Another alternative is to use an adjacent cell to do the
conversion for you (this may not be acceptable). You
can use a formula thus:

=TIMEVALUE(LEFT(D5,2)&":"&RIGHT(D5,2))


where D5 contains your number.