how to convert minutes into centiminutes

"The data in cell D2 is 7h44m45s and the result is 7.245833 centiminutes

so I belive it works"

Assuming the "." is the decimal separator, that result says that a duration of more than seven hours is the same as a duration of approximately seven centiminutes.

Seven centiminutes is seven hundredths of a minute, which is less than five seconds.

Let's look at the math on 'paper':

7 hours = 420 minutes (7x60)

44 minutes = 44 minutes

45 seconds = 0.75 minutes

Total: 464.75 minutes

which is 46475 centiminutes

See Row 2.

The closest I can get to your numerical result is by using =DUR2DAYS(B2)*24, or STRIPDURATION(B2)*24 both of which give the result 7.74583333... (hours). See the yellow filled rows above.

DUR2DAYS converts a duration value to the equivalent number of days and decimal fraction of days. Multiplying that by 24, the number of hours in a day, gives the number of hours and decimal fraction of hours represented by that value.

Regards,

Barry

PS: must have been in a hurry earlier.

I notice I said "centiseconds" in my reply to Bressen above—should have been "centiminutes".

And in my reply to my own earlier message, I said the duration value was in F5, while the formula clearly required it to be in B2.

My bad!

B

EDIT

PPS:

I was able to get 7.2458333... after all. That is the correct value for the conversion of 7h 14m 45s to hours.

B

Message was edited by: Barry

What is the current format of your minutes data?

If the current data is a number (not a duration or a date and time value), then simply multiplying the number by 100 will give you the equivalent number of centiminutes.

If the current data is a Duration, then the formula below will return the number of centiminutes in that Duration. Duration value is in cell F5:

=24*60*100*(STRIPDURATION(F5))

Regards,

Barry

If the source value is in F5 and is a date_time one,

use :

=TIMEVALUE(F5)*24*60*100

Yvan KOENIG (VALLAURIS, France) lundi 1 août 2011 11:41:18

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

Bressen wrote:

I am using a Danish vertion og Numbers and I found that this works =(FINDVARIGHED(D2))*24

And it would be somthing like this in the English vertion =(FIINDDURATION(D2))*24

Hi Bressen,

I'm having trouble seeing how multiplying a value by 24 would convert that value into hundredths of minutes. What type of data is in cell D2?

For a Duration value of 1h 1m 45s, the formula should return a Number value of 6175 (centiseconds).

Regards,

Barry

I took another look at this after Bresson's reply, and found a better version of my earlier response.

Barry wrote:

"If the current data is a Duration, then the formula below will return the number of centiminutes in that Duration. Duration value is in cell F5:

=24*60*100*(STRIPDURATION(F5))"

New version (still for a Duration value in F5):

=DUR2MINUTES(B2)*100

Regards,

Barry

In fact, you converted 7h44m45s into 7.245833 decimal hours.

Yvan KOENIG (VALLAURIS, France) dimanche 4 janvier 2011 20:34:57

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

As far as I remember, when we import from Excel we don't get Duration values but Date Time ones.

So I assume that in fact your cell contain a Date Time value.

Try to apply the formula :

=TIMEVALUE(D2)*24

Yvan KOENIG (VALLAURIS, France) dimanche 4 janvier 2011 22:47:32

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

I would believe it if the result was 46475 centiminutes.

Jerry