Time to Number Conversion
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
|