Thread: [Solved] Excel 2007 and data in dd:hh:mm:ss format
View Single Post
 
Old 11-05-2011, 05:19 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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,

For a 'dd:hh:mm:ss' string in A1, the following formula will convert the 'hh:mm:ss' portion to a timevalue:
=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)
Once you've done that for all the cells, you should be able to use the column containing the timevalues in your chart.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote