How do I enter a formula that counts the duration spent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a statics sheet in excell and need to calculated the total time
spent on several different clients/projects in a day to show the total time
spent. Does anyone have a formula for this please.
 
If you have a start time in one column and a finish time in another,
just subtract the start time from the finish time, assuming the times
are in Excel time format.

Hope this helps.

Pete
 
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
using two cells 1 with total time n 1 with date how can i put the. 2
How enter time DURATIONS mm:ss (not clock times), then sum? 1
sum across range of sheets for a cost code 1
Average of time spent monthly getting DIV/0 error 2
Calculating time without using time functions... 4
Time Spent 2
How do I calculate the hours spent on a project by entering a sta. 4

Back
Top