how do i calculate minutes between two times?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
I'm confused.

Isn't the duration the difference between the start time and whatever the end
time is?
 
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
 
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)
 
"Under the hood", times ARE just plain numbers, specifically the fraction of a
24-hour day.
 
Back
Top