How to format cell in order to display *both* time and date

		Microsoft Office Forums > Microsoft Excel > Excel
*How to format cell in order to display both* time and date**

FAQ

Thread Tools

Display Modes

10-20-2012, 11:36 PM

Kevin@Radstock Kevin@Radstock is offline

Windows 7 32bit How to format cell in order to display *both* time and date

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Do you require to combine the date & time int 1 cell! If so: =H1+I1 copy down & format the cells as you require. IE: dd/mm/yyyy hh:mm AM/PM depending on your regional settings.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
display in meeting 'When' show old time on 2007-10 but not in 2003	andrelabbe	Outlook	0	07-18-2012 03:01 AM
Add a period of time to a referenced "Time" cell?	derelyth	Excel	4	03-27-2011 04:31 PM
how to display expired date in red (access)	iffy	Office	5	01-16-2011 06:28 AM
How To Open Documents in Date Modified Order	diver9	Word	0	08-29-2010 03:34 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 PM.