Calculating the difference between date/time fields? My calc using Date/Time fields is [Finish Date/Time] - [Start Date/Time] -I need my result to show hours:minutes...

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have an app that's tracking how much time my newborn son is sleeping and I need to calculate the difference between the finish time and start time and account for the time between 2 different days. More specifically, if he falls asleep at 23:30 on a Saturday and awakes at 03:00 on a Sunday i need my result to show 3.5 hours. 

I'm using two Date/Time fields with a formula of [Finish Date/Time]-[Start Date/Time] but my result is is something like this: 12-31-1969 07:32 PM. 

Any help would be appreciated...
Photo of Chris Collins

Chris Collins

  • 70 Points

Posted 2 years ago

  • 0
  • 1
Photo of Chris Collins

Chris Collins

  • 70 Points
I figured it out...thanks
Photo of Jeff

Jeff

  • 186 Points 100 badge 2x thumb
Not helpful :(
Photo of Stephen

Stephen

  • 60 Points
Not Helpful, didn't explain how they "figured it out"~!
If you have a question, I suggest that you post a question.
Photo of Stephen

Stephen

  • 60 Points
I was researching questions already asked and came across this one.  this wasn't helpful in anyway so I agreed with Jeff from 2 months ago, that way others who made need help with this subject would know that this article was pretty much not helpful.  

I would rather research my question first before submitting an identical (or close to identical one) in the forum rather than waste other peoples time re-answering a question that was already asked previously.

Now both of us have wasted our time on an article and replies that are not help to either one of us. 

Oh and P.S. I did find the answer I was looking for in another post, and am going to try it to see if it works for us.
Photo of Jeff

Jeff

  • 186 Points 100 badge 2x thumb
Please let us know what you find out!
Photo of Stephen

Stephen

  • 60 Points
This is what we're going to try, will let you know if it works for us..

ToTimestamp([IssueDate])-ToTimestamp([Resolveddate]) 
Photo of Stephen

Stephen

  • 60 Points
This did not work, back to researching.
Stephen, you should be able to use a formula duration field type  and set the units to display as HH:MM

[Finish Date/Time]-[Start Date/Time]
Photo of Stephen

Stephen

  • 60 Points
Thank you, I will try this out and get back with you.  I appreciate the help.