Time to Number Conversion

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
 
T

T. Valko

Do you mean you want to convert 0:47 to decimal 47?

Multiply by 1440:

=A1*1440

Format as General or Number
 
J

John Calder

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top