how do i calculate minutes between two times?

[Guest]

DI hope someone can help me. I receive a spread sheet hat I want to
calculate the time in between two times. I receive the data in the following
format Cell A1 (start time)= 7:42:00 (hr:min:sec) / Cell B2 (Duration) = 5.0
(5 minutes). A2 and B2 would be the second time and duration. I would
like to calculate the length between A2 and B2. Anyone have any ideas

 

[Dave Peterson]

I'm confused.

Isn't the duration the difference between the start time and whatever the end
time is?

 

[Guest]

You just have to have cell c1 formatted as time then have b2 - a1
Peterm

 

[Guest]

Sorry, I don't think I explained everything well enough. Cell A1 is the
start time, Cell A2 is the length of the call. Cell A1 is the start time of
the second call. I want to calculate the "idle" time between calls. If they
were just plain numbers the formula would be: =(A1+A2)-B1. If anyone could
leave me there e-mail, I could send the spread sheet to you so you can see
better what I am looking for.

Thanks again!
Ron

 

[Dave Peterson]

A1 is the start time of the first call?
B1 is the duration (in minutes) of the first call?
A2 is the start time of the second call?

=a2 - (a1+(b1/24/60))

If you entered the duration as a time, it would look a little prettier:

=a2 - (a1+b1)

 

[Myrna Larson]

"Under the hood", times ARE just plain numbers, specifically the fraction of a
24-hour day.