#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Hi Sammael,
We need to split apart the time into its respective hour and minute components by using string functions and then join them back together again as a valid time. Lets just say we have the times in column A Follow these steps:
|
#3
|
||||
|
||||
Or in one go perhaps
Code:
=(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))+0
__________________
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 |
Thread Tools | |
Display Modes | |
|
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 |