Time to Number Conversion

  • Thread starter Thread starter John Calder
  • Start date Start date
J

John Calder

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
 
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
 
Back
Top