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)
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)
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
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 !
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
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
The data type is duration and the calculation is correct just like in the Excell spreadsheed
Regards
Frede
The data in cell D2 is 7h44m45s and the result is 7.245833 centiminutes
so I belive it works
I would believe it if the result was 46475 centiminutes.
Jerry
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
"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
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
how to convert minutes into centiminutes