Calculating Time Elapsed

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

Greetings!

I would like to ask if someone can steer me in the right direction here.

Column A is start time, column B is stop time. Column C is the number
minutes elapsed between A and B. I can't seem to find what the formula is
in the Help menus.

A B C
08:30 09:50 80

Thanks!

Fred
(e-mail address removed)
 
Just format the cells as time and subtract one from the other. Tha
will give you the correct number of hours:minutes that one differs fro
the other
 
Formula: =B1-A1 with Format of [m]
Formula: =(B1-A1)/"0:1" with Format of General
Formula: =(B1-A1)*60*24 with Format of General
 
Greetings!

I would like to ask if someone can steer me in the right direction here.

Column A is start time, column B is stop time. Column C is the number
minutes elapsed between A and B. I can't seem to find what the formula is
in the Help menus.

A B C
08:30 09:50 80

Thanks!

Fred
(e-mail address removed)
 
Greetings!

I would like to ask if someone can steer me in the right direction here.

Column A is start time, column B is stop time. Column C is the number
minutes elapsed between A and B. I can't seem to find what the formula is
in the Help menus.

A B C
08:30 09:50 80

Thanks!

Fred
(e-mail address removed)
 
XL stores times as fractional days, so you need to multiply by 24*60:


C1: =(B1 - A1) * 1440

If your times span midnight, you have to do some further manipulation,
since the "later" time will be a smaller value than the "earlier time"
(e.g, 21:00 = 0.875, 3:00 = 0.125). You can use the fact that a
TRUE/FALSE value is interpreted as 1/0:

=((B1 - A1) + (B1 < A1)) * 1440

or you can use the more obscure, but equivalent

= MOD(B1 - A1, 1) * 1440
 
Back
Top