Microsoft Office Forums - View Single Post - How to format cell in order to display *both* time and date

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

View Single Post

Old

10-20-2012, 11:36 PM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 7 32bit

Windows 7 32bit Kevin@Radstock uses Office 2010 32bit

Kevin@Radstock uses Office 2010 32bit

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

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.

Reply With Quote