I need to fin how many minutes are between two hours...for example:

10:30am to 1:30pm

I have tried to subtract both times and then custom format the cell [mm]
which will work......but I am trying to make another calculation with that
result and it gives me a number that really is not what I expect......it
should be a simple subtraction 180 minus whatever number.

is there an easier way to get the total minutes between to times without
having to custom format the cell?.....thanks

Try it this way:

=(B1-A1)*24*60

and then format the cell as General or as Number. This assumes that B1
is the later time than A1.

Hope this helps.

Pete

On Jul 2, 9:32*pm, jcheko <jch...@discussions.microsoft.com> wrote:
> I need to fin how many minutes are between two hours...for example:
>
> 10:30am to 1:30pm
>
> I have tried to subtract both times and then custom format the cell [mm]
> which will work......but I am trying to make another calculation with that
> result and it gives me a number that really is not what I expect......it
> should be a simple subtraction 180 minus whatever number.
>
> is there an easier way to get the total minutes between to times without
> having to custom format the cell?.....thanks

it worked thanks....

"Pete_UK" wrote:

> Try it this way:
>
> =(B1-A1)*24*60
>
> and then format the cell as General or as Number. This assumes that B1
> is the later time than A1.
>
> Hope this helps.
>
> Pete
>
> On Jul 2, 9:32 pm, jcheko <jch...@discussions.microsoft.com> wrote:
> > I need to fin how many minutes are between two hours...for example:
> >
> > 10:30am to 1:30pm
> >
> > I have tried to subtract both times and then custom format the cell [mm]
> > which will work......but I am trying to make another calculation with that
> > result and it gives me a number that really is not what I expect......it
> > should be a simple subtraction 180 minus whatever number.
> >
> > is there an easier way to get the total minutes between to times without
> > having to custom format the cell?.....thanks
>
>

You're welcome - thanks for feeding back.

Pete

On Jul 2, 10:17*pm, jcheko <jch...@discussions.microsoft.com> wrote:
> it worked thanks....
>