Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert 00:06 minutes to 6
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert 00:06 minutes to 6
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. your time in A1. Then: =A1*1440 and format "General" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert 00:06 minutes to 6
Hi Ditchy,
Am Sat, 9 Jul 2011 09:58:53 +0200 schrieb Claus Busch: your time in A1. Then: =A1*1440 and format "General" time * 1440 converts all times to minutes. If you only want to extract the part with minutes then try: =MINUTE(A1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text entered as minutes/seconds to minutes | Excel Worksheet Functions | |||
I need to convert 157.25 minutes, into hours, minutes and seconds. | Excel Discussion (Misc queries) | |||
Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions |