Showing posts with label Calculator. Show all posts
Showing posts with label Calculator. Show all posts

Thursday, July 26, 2012

Date and Time Difference calculator

Look what I just found!!!


=DATEDIF([In-Progress Time],[Closed time]-(MOD([In-Progress Time],1)>MOD([Closed time],1)),"d")&" days, "&TEXT(MOD([Closed time]-[In-Progress Time],1),"hh "" hrs, "" mm "" mins""")
- No comments:
Labels: , , ,
Subscribe to: Posts (Atom)
  • configuring a web part
    here's the tip for today.... You know how when you add an out-of-the-box web part that requires configuration you get a nice little mes...
  • Sharepoint Tweeks and tricks
    Is this even possible, some might wonder? Well it is, via querystring options on the command line: Add Web Parts/Browse   ToolPaneView=2 ...
  • Overcoming Corruption: A Call to Personal Transformation
    Dear brothers and sisters, In a world tainted by corruption, we often find ourselves lamenting the state of affairs and expecting the govern...

Followers

No Locks without Key

🌿 Bible Verse 1 Corinthians 10:13 "No temptation has overtaken you except what is common to mankind. And God is faithful; ...

Who Am I?

My photo
What is mankind that you are mindful of them, human beings that you care for them? Psalms 8:4 But he made us a little lower than Angels and Crowned with Glory and Honor. How majestic is your name in all the Earth Oh Lord our God!