Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

how to convert minutes into centiminutes

In Excell I can use (time)*24 and get the value as centiminutes is there a simular way to do et in Numbers?

MacBook Pro, Mac OS X (10.7)

Posted on Jul 31, 2011 11:53 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 1, 2011 12:13 AM

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

11 replies
Sort By: 
Question marked as Top-ranking reply

Aug 1, 2011 12:13 AM in response to Bressen

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

Reply

Aug 1, 2011 2:41 AM in response to Bressen

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 !

Reply

Dec 4, 2011 11:04 AM in response to Bressen

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

Reply

Dec 4, 2011 11:02 AM in response to 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

Reply

Dec 4, 2011 11:35 AM in response to Bressen

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



Reply

Dec 4, 2011 1:35 PM in response to Bressen

"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.

User uploaded file

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

Reply

Dec 4, 2011 1:47 PM in response to Bressen

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



Reply

how to convert minutes into centiminutes

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.