If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Time to Number Conversion
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|