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 |
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 |
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 |
All times are GMT +1. The time now is 06:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com