Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Worksheet Functions | |||
Time Conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Worksheet Functions | |||
Time conversion | Excel Discussion (Misc queries) |