Converting data format within a cell
 

I receive a spreadsheet with data that I need to copy and paste this in to
another spreadsheet.

The data appears as follows in the following format:
1378:20:00
675:00:00
11:40:00
1:40:00
0:00

I need to write a formula or convert this into the following format:
1378.20
675.00
11.40
1.40
0.00

How can this be accomplished?

Converting data format within a cell
 

Hi,

I replied to your other post, if you have any problems with that one then
it's probably best to continue on that post.

Cheers,

Sean.
--
(please remember to click yes if replies you receive are helpful to you)


"rylv5050" wrote:

I receive a spreadsheet with data that I need to copy and paste this in to
another spreadsheet.

The data appears as follows in the following format:
1378:20:00
675:00:00
11:40:00
1:40:00
0:00

I need to write a formula or convert this into the following format:
1378.20
675.00
11.40
1.40
0.00

How can this be accomplished?