Total of Time

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
 
J

JE McGimpsey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Receiving unexpected Duration 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Work Budget Salary vs Real Time Salary 0
Showing 24 hour time along X-axis 0
adding up event durations? 1
adding cells with text 1
Setting up a chapter a word-count inventory for a novel 1
Fixed duration task and associated time budgets....help 0

Top