Time

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

Can anyone help me calculate time. I simply want to add a column of
minutes spent to determine total duration. :eek:
 
If you can give us more information on how your data is displayed an
your desired output format, I'm sure someone can help you.

How are your times listed in your column? hh:mm; mm:ss; hh:mm:ss
etc.? How do you want the sum of the times to be displayed... hh:mm
hh.n (e.g. 1.5 for 90 minutes)?

Please give examples of your data and your expected results
 
One way:

=SUM(A1:A1000)

Format the cell with Format/Cells/Number/Custom [h]:mm

or another time format. The brackets keep the value from rolling over
(e.g., 25 hours will appear as 25:00 rather than 1:00).
 
You must log in or register to reply here.

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

Excel Sumproduct 0
dd:hh:mm:ss 2
Excel Excel calculate pay based on rate per minute 7
Duration stored as text 1
How do I convert hours to days? 2
Adding minutes to hours/minutes 4
Calculating Hours, Minutes and Seconds 6
Determining availability time 1

Back
Top