Need a formula to calculate time between open and closed dates and times

**DebbieF** · 06-10-2011, 05:44 AM

I need a formula that will calculate the time difference in hours and minutes between when a ticket was opened to when it was closed. Our company functions 24 hours a day 7 days a week inlcuding public holidays so it must include all of these. An example is the ticket was opened on the 06/06/2011 at 15.40pm and was closed on the 06/06/2011 at 16.15pm

**TMS** · 06-10-2011, 06:24 AM

You should just be able to subtract the two dates/times and format the result as [hh]:mm.

Failing that, have a look at DATEDIFF

There have been a couple of threads recently on a similar vein but more complex because they're not 24x7x365

Regards

**DebbieF** · 06-10-2011, 09:51 AM

Wow that is so simple thank you so much. It works perfectly

**TMS** · 06-10-2011, 02:18 PM

You're welcome.

If this has answered your question, please mark the thread as solved. See my signature for details or the FAQ.

Regards

**eswar12** · 05-02-2012, 11:58 PM

Hi... i need formula for finding difference in two times. our production plan is like
8 AM TO 8.45AM 0.45 ( NEED FORMULA FOR THIS)
8.45AM TO 11.30 AM 2.45 ( NEED FORMULA FOR THIS)
11.30 AM TO 12.45 AM 1.15 ( NEED FORMULA FOR THIS)
PLEASE HELP ME IN THIS ISSUE.

**arlu1201** · 05-03-2012, 02:45 AM

Eswar12,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.