Time

T

tracyt620

Hi

I'd like to work out time in a cell i.e. if i have three cells on th
1st I want to enter a start time (10.00) in the second I want to ente
a finish time (10.10) and in the third i want to find the sum on th
second minus the first. The problems comes because I want to show th
time in the third column in minutes. I also want to sum these so tha
at the bottom all my entries in the third colum show up as hours an
minutes

any suggestion
 
C

Chip Pearson

Tracy,

In your third column, simply subtract the start time from the end
time, e.g.,

=B1-A1

Format this cell for minutes, [mm]. In your sum cell, simply add
up the elapsed times, e.g.,

=SUM(C1:C10)

and format the cell as [hh]:mm
 
Top