Formulas in a Time Study

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

What is the formula for subtracting two times and then
summing the difference. For example, A1=8:30am,
B1=8:45am...the time elapsed = text(b1-
a1,"h:mm")...repeat the following for the next 4
rows...how do you sum the "time elapsed" column to =
hours and minutes? Please indicate how cells should be
formatted to accomodate all statistical & mathematical
formulas. Thanks!
 
Dee
First of get rid of the text function. Just use =B1-A1 and then custom format the cell with a number format of [h]:mm. Now you can use regular functions on the differences

Good Luck
Mark Graesse
(e-mail address removed)

----- Dee wrote: ----

What is the formula for subtracting two times and then
summing the difference. For example, A1=8:30am,
B1=8:45am...the time elapsed = text(b1
a1,"h:mm")...repeat the following for the next 4
rows...how do you sum the "time elapsed" column to =
hours and minutes? Please indicate how cells should be
formatted to accomodate all statistical & mathematical
formulas. Thanks
 
First a question. Is there the possiblity of the times
crossing midnight? It would affect how the formula has to
be written.
 
Back
Top