Thread: [Solved] Excel 2007 and data in dd:hh:mm:ss format
View Single Post
 
Old 11-05-2011, 06:23 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote