Changing format of time data

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

FAQ

Thread Tools

Display Modes

04-03-2012, 01:09 PM

Sammael

Windows 7 64bit Changing format of time data

Office 2007

Novice

Join Date: Nov 2011

Posts: 8

Changing format of time data

I have time data formatted together, like 1040 for 10 hours 40 minutes and 611 for 6 hours 11 minutes.

How can I change this data into form that Excel 2007 would understand it as time?

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 09:59 PM.