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

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 ?
 
F

Frank Kabel

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
 
B

BrianB

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dd:hh:mm:ss 2
changing date formats 2
Timesheet help 2
Working with duration data 3
Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute 7
Convert hours to days 8
Convert Time: HH:MM to HH and tenths of hours 3
Formula to convert Hours to Days, Hours Minutes 1

Top