Excel 2007 and data in dd:hh:mm:ss format

		Microsoft Office Forums > Microsoft Excel > Excel
Excel 2007 and data in dd:hh:mm:ss format

FAQ

Thread Tools

Display Modes

11-05-2011, 06:23 AM

macropod

Windows 7 64bit Excel 2007 and data in dd:hh:mm:ss format

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

Hi Sammael,

That suggests your PC's regional settings are configured to use ';' where I've used ','. Try:
=TIMEVALUE(RIGHT(A1;LEN(A1)-FIND(":";A1)))
or, if you also have different days for some of the times:
=TIMEVALUE(RIGHT(A1;LEN(A1)-FIND(":";A1)))+LEFT(A1;FIND(":";A1)-1)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

date, excel 2007, time

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create microsoft Excel 2007 and 2010 File in .xlsx format	ipacesetters	Excel	1	12-16-2019 05:13 PM
Excel 2007 cell format help!!!	Raner	Excel	4	06-17-2013 11:13 PM
Excel 2007 data question	Paul-NYS	Excel	3	09-26-2011 10:49 PM
How to restore original data format - from a .pdf file to Excel columns	KIM SOLIS	Excel	1	09-18-2011 10:49 PM
Format Excel to look like Word	Kilconey	Excel	1	04-30-2010 09:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 PM.