Time to Number Conversion

Hi

I run Excel 2K

I download data from a mainframe.

One of the entries that is download is a value that represents minutes (or
hours) that reflect the duration of a process delay.

Example 1
0:47 (which represents 47 minutes.

Example 2
8:23 (which represents 8 hrs and 23 minutes)

Here is my problem.

Although it shows 0.47 in the cell, in the edit bar it shows 12:47:00 AM.

as does 8:23 show as 8:23:00 AM.

I need a formula that can look at these cells and convert them to a number
format of actual minutes. These numbers will then be totalled using a pivot
table.

Is this possible?


Thanks

Do you mean you want to convert 0:47 to decimal 47?

Multiply by 1440:

=A1*1440

Format as General or Number

--
Biff
Microsoft Excel MVP


"John Calder" wrote in message
...
Hi

I run Excel 2K

I download data from a mainframe.

One of the entries that is download is a value that represents minutes (or
hours) that reflect the duration of a process delay.

Example 1
0:47 (which represents 47 minutes.

Example 2
8:23 (which represents 8 hrs and 23 minutes)

Here is my problem.

Although it shows 0.47 in the cell, in the edit bar it shows 12:47:00 AM.

as does 8:23 show as 8:23:00 AM.

I need a formula that can look at these cells and convert them to a number
format of actual minutes. These numbers will then be totalled using a
pivot
table.

Is this possible?


Thanks

Well Done !

This looks like it may be the answer....I will let you know once I have
tried it out on a bigger data set

Thanks

John


"T. Valko" wrote:

Do you mean you want to convert 0:47 to decimal 47?

Multiply by 1440:

=A1*1440

Format as General or Number

--
Biff
Microsoft Excel MVP


"John Calder" wrote in message
...
Hi

I run Excel 2K

I download data from a mainframe.

One of the entries that is download is a value that represents minutes (or
hours) that reflect the duration of a process delay.

Example 1
0:47 (which represents 47 minutes.

Example 2
8:23 (which represents 8 hrs and 23 minutes)

Here is my problem.

Although it shows 0.47 in the cell, in the edit bar it shows 12:47:00 AM.

as does 8:23 show as 8:23:00 AM.

I need a formula that can look at these cells and convert them to a number
format of actual minutes. These numbers will then be totalled using a
pivot
table.

Is this possible?


Thanks