I've tried converting say 02:30 (hr min) into minutes by using Custom format
mm ss - but it doesn't seem to work.

What the correct way to do this?

many thanks

[m]:ss

or
[m]


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Zakynthos" <(E-Mail Removed)> wrote in message news:90FC0441-4572-46FE-A3F2-(E-Mail Removed)...
| I've tried converting say 02:30 (hr min) into minutes by using Custom format
| mm ss - but it doesn't seem to work.
|
| What the correct way to do this?
|
| many thanks

Many thanks - I did try that but it didn't work!!! only giving the minutes as
a result and ignoring the hours eg 02:30 was formatted as 30

I then tred a Google search as I needed the answer urgently and found that
multiplying by 24 then by 60 then formatting result as whole number did the
trick.

"Zakynthos" wrote:

> I've tried converting say 02:30 (hr min) into minutes by using Custom format
> mm ss - but it doesn't seem to work.
>
> What the correct way to do this?
>
> many thanks

On Mar 23, 5:47 am, Zakynthos <Zakynt...@discussions.microsoft.com>
wrote:
> Many thanks - I did try that but it didn't work!!! only giving the minutes as
> a result and ignoring the hours eg 02:30 was formatted as 30
>
> I then tred a Google search as I needed the answer urgently and found that
> multiplying by 24 then by 60 then formatting result as whole number did the
> trick.
>
>
>
> "Zakynthos" wrote:
> > I've tried converting say 02:30 (hr min) into minutes by using Custom format
> > mm ss - but it doesn't seem to work.
>
> > What the correct way to do this?
>
> > many thanks- Hide quoted text -
>
> - Show quoted text -

Try the "MINUTE" function in Excel. Search Excel Help "Minute" to see
how it works exactly. If you go to Menu Bar: Insert/Function, and
change the drop down box to "Date & Time" you'll see a number of time
functions that are available to you. You shouldn't have to do
x*24/60.

Matt

Matt,

Thanks for your help on this - I really appreciate your comments - too late
for today's work but I'll certainly use it on future occasions.

Best wishes,

Tony

"matt" wrote:

> On Mar 23, 5:47 am, Zakynthos <Zakynt...@discussions.microsoft.com>
> wrote:
> > Many thanks - I did try that but it didn't work!!! only giving the minutes as
> > a result and ignoring the hours eg 02:30 was formatted as 30
> >
> > I then tred a Google search as I needed the answer urgently and found that
> > multiplying by 24 then by 60 then formatting result as whole number did the
> > trick.
> >
> >
> >
> > "Zakynthos" wrote:
> > > I've tried converting say 02:30 (hr min) into minutes by using Custom format
> > > mm ss - but it doesn't seem to work.
> >
> > > What the correct way to do this?
> >
> > > many thanks- Hide quoted text -
> >
> > - Show quoted text -
>
> Try the "MINUTE" function in Excel. Search Excel Help "Minute" to see
> how it works exactly. If you go to Menu Bar: Insert/Function, and
> change the drop down box to "Date & Time" you'll see a number of time
> functions that are available to you. You shouldn't have to do
> x*24/60.
>
> Matt
>
>