Microsoft Excel 2010 Help

How do I correctly format text to show a certain time in this way:
XX:XX XX
ie: 01.00 am
ie: 14.00 pm
Then is it possible to find the difference between 2 times in excel, then with the total hours subtract Xmins?
Answer #1
give this a try
Insert the current date and time in a cell
http://office.microsoft.com/en-us/excel-help/insert-the-current-date-and-time-in-a-cell-HP010342622.aspx?CTT=1