convert 00:06 minutes to 6

  • Thread starter Thread starter Ditchy
  • Start date Start date
D

Ditchy

Hello
how can I convert 00:06 minutes to 6
tried the =RIGHT(AA8,LEN(AA8)-4)*1
but can't seem to get it to work?
could some one please point me in the right direction.
regards
Ditchy
 
Hi Ditchy,

Am Sat, 9 Jul 2011 00:39:57 -0700 (PDT) schrieb Ditchy:
how can I convert 00:06 minutes to 6
tried the =RIGHT(AA8,LEN(AA8)-4)*1
but can't seem to get it to work?
could some one please point me in the right direction.
Click to expand...

your time in A1. Then:
=A1*1440 and format "General"


Regards
Claus Busch
 
Hi Ditchy,

Am Sat, 9 Jul 2011 09:58:53 +0200 schrieb Claus Busch:
your time in A1. Then:
=A1*1440 and format "General"
Click to expand...

time * 1440 converts all times to minutes. If you only want to extract
the part with minutes then try:
=MINUTE(A1)


Regards
Claus Busch
 
Back
Top