When writing reports, sometimes you need to remove the date and just view the time….perhaps in the case of an appointment time, or a manager is checking up on his/her employees because they didn’t finish something on time.
1) Make sure that your column is a textbox. If not drag a textbox from the toolbox into the cell.
2) Right-click textbox, and choose ‘Text Box Properties…’
3) Click on ‘General’ on the left-hand side. Look for the ‘Value:’ prompt, and click ‘fx‘.
4) Paste the following:
This code will take this:
And format it to look like this: