Day/Time Data to Something Useful?

[Clu]

Good morning everyone,

This is my first post here, and I'm hoping that someone here will understand this better than I do.

I am trying to use a number value in the following format: 000:00:43:48. This format is obviously ddd:hh:mm:ss. This format is very interesting as excel is allowing me to use it for virtually nothing.

For example, I am trying to multiply the number of minutes in the value by a sum of three other numbers.

So it would be =000:00:43:48*SUM(50+11+112).

This is turning up an #VALUE! when I run it in Excel.

Any ideas?

Clu

 

[thunder_anger]

Welcome

what are the numbers in brackets??

 

[Yard]

Hi, welcome to Mr Excel.

It's perhaps not as obvious as you suggest....do you mean you want to multiply 43m 48s by 173 and have the results displayed in days, hours, minutes and seconds?

If so I don't believe that number format will work, since "d" is used in a calendar sense, not in a counting sense.

 

[Clu]

The numbers in brackets are some counts that I'm working with.

Clu

 

[Clu]

Hi, welcome to Mr Excel.

It's perhaps not as obvious as you suggest....do you mean you want to multiply 43m 48s by 173 and have the results displayed in days, hours, minutes and seconds?

If so I don't believe that number format will work, since "d" is used in a calendar sense, not in a counting sense.

Let me open this up a little more. I am working for a communications company that is trying to calculate Subscriber Minutes in outage. So the time there is the actual duration of the outage, and the other numbers are the subscriber counts. So I guess the question is, how do I get the minutes from the current report format? Any ideas?

Thank you!
Clu

 

[thunder_anger]

you can isolate Minutes nd do your thing "suggestion"

 

[Yard]

So the input you have to work with is a text string like "000:00:43:48" ?

 

[Clu]

So the input you have to work with is a text string like "000:00:43:48" ?

We verified and matched it, it is a number.

Clu

 

[Yard]

I'm not following this. Take the cell which contains the 000:00:43:48 value, and format it as General. What value is now in the cell?

 

[Clu]

It's already formatted as general.

Clu