Tracking Time in Excel

D

Dale M

I need to enter blocks of time (h:mm) in Excel and have it to generate
a total in each column. How can this be done correctly?
 
M

Mark

Dale,

How do you want the total? Also h:mm or h.99?

If you want it to remain h:mm, just format all of the cells as hh:mm and a
simple sum formula will work.

Mark
 

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

Formatting question: how to format duration (time spent)? 0
Insert name and adress from a list in a word document 1
Merging from an Excel file with graphics 1
Autonumber field in Excel that behaves the same as Access 0
How To Rapidly Copy Formulas? 0
Tracking text changes 0
Blocking junk email 0
Data consolidation 0

Top