Changing format of time data

		Microsoft Office Forums > Microsoft Excel > Excel
Changing format of time data

FAQ

Thread Tools

Display Modes

04-08-2012, 12:13 PM

Pecoflyer

Windows 7 64bit Changing format of time data

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Or in one go perhaps

Code:

=(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))+0

and format as h:mm

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

conversion, excel 2007, time

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 and data in dd:hh:mm:ss format	Sammael	Excel	6	11-05-2011 06:52 AM
How to restore original data format - from a .pdf file to Excel columns	KIM SOLIS	Excel	1	09-18-2011 10:49 PM
Font colour and format changing?	Lamya	Word	5	05-16-2011 02:35 AM
changing font size without changing leading	carolns	Word	1	09-14-2009 12:30 PM
Recurring Appointment randomly changing time	rkryd03	Outlook	0	03-06-2007 10:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:22 AM.