changing data format from DD:hh:mm:ss to hours

  • Thread starter Thread starter chris.howes
  • Start date Start date
C

chris.howes

I have data that has been imported from a bespoke reporting programm
and it supplies time in the format
DD:HH:MM:SS (Days,Hours,Minutes,Second) and i need to convert thi
into straight HH.MM so i can perform a mathermatical function on it ho
do i do this ?
 
Hi
try the following formula (if your date is in column A)
=TIME(--MID(A1,4,2),--MID(A1,7,2),0)
this will truncate the seconds and days
 
Hopefully, by just reformatting the cells.

If the data is in text format, you may need to select the cells afte
formatting and use menu Data/Text to Columns/Finish
 
Back
Top