Total of Time

  • Thread starter Thread starter A
  • Start date Start date
A

A

I'm recording the time I spend working on a piece of work in a spreadsheet
along with meeting details etc.
I've 2 columns that are start and finish times and a third that works out
duration.
I then want to total the duration into total hours but I can't find a way to
do this
Any help please
TIA
 
Assuming your duration is in column C, just use

=SUM(C1:C100)

XL's default display will "roll over" every 24 hours. To get the actual
total, choose Format/Cells/Number/Custom

[h]:mm
 
Back
Top