Microsoft Office Forums - View Single Post - Changing format of time data

Thread: Changing format of time data

View Single Post

Old

04-03-2012, 01:09 PM

Sammael

Sammael is offline

Sammael uses Windows 7 64bit

Windows 7 64bit Sammael uses Office 2007

Sammael uses Office 2007

Office 2007

Novice

The original poster

Join Date: Nov 2011

Posts: 8

Sammael is on a distinguished road

Default

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?

Reply With Quote