Convert 13 hours a 10 minutes to total minutes

J

John

I would like to track production start/stop times and then
convert the total time to minutes instead of hours and
minutes.
I have been using a formula like the one below for
figuring the total time
=(B1-A1+(B1<A1)) and that works fine.

A1: Start A2: Stop Total
1:00 am 3:15 am 2:15

What I would like to do is convert the total (2HR:15MIN)
to 135 minutes
 
J

James Silverton

John said:
I would like to track production start/stop times and then
convert the total time to minutes instead of hours and
minutes.
I have been using a formula like the one below for
figuring the total time
=(B1-A1+(B1<A1)) and that works fine.

A1: Start A2: Stop Total
1:00 am 3:15 am 2:15

What I would like to do is convert the total (2HR:15MIN)
to 135 minutes

When I try it with start and stop in A and B and formatted as time, simply
multiplying by 1440 seems to work or, am I missing something? (g)
 

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