Time

[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

 

[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

 

[David McRitchie]

Hi Tracy,
What does 10.00 represent as time hours or minutes?
If hours divide by 24 to get time, which you can then
format as time. More information on date and time in
http://www.mvps.org/dmcritchie/excel/datetime.htm

 

[tracyt620]

thanks this worked perfectl