Diference between two hours in Minutes

J

jcheko

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
 
P

Pete_UK

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
 
J

jcheko

it worked thanks....

Pete_UK said:
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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top