How do I calculate the hours spent on a project by entering a sta.

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

Guest

I am trying to make a spread sheet that I can enter a starting time and and
ending time to treack the amount of hours spent on projects. I format my
starting and ending times cells as times but I can not figure out the formula
to use to take these times and calculate the amount of time between them. If
anyone knows how to do this please let me know. You can email me at
(e-mail address removed). Thanks for the help.
 
Just subtract the times. With Start time in A1 and End time in B1

=B1-A1
 
There could be a possibility that the end time is lower than Start time
where the time spills over to the next day.

To cover such cases, you can use

= IF(B1<A1,B1+1-A1,B1-A1)

Regards

Govind.
 
Good point

Without the IF

B1-A1+(A1>B1)


Govind said:
There could be a possibility that the end time is lower than Start time
where the time spills over to the next day.

To cover such cases, you can use

= IF(B1<A1,B1+1-A1,B1-A1)

Regards

Govind.
Click to expand...
 
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

Calculate After hours 3
How do I calculate total hours by rate of pay? 1
Calculate elapsed time excluding specific timeframe 10
calculate total hours based on dates 5
How do I enter a formula that counts the duration spent 1
Calculate number days + hours to complete a project 1
Time Functions 4
calulating a certain weekday hours within a 24 hour roster 2

Back
Top