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