Solved

Resulting two date time fields in SharePoint

Posted on 2014-09-05
2
229 Views
Last Modified: 2014-09-05
I am working on a formula to take two date and time fields and outputting the result in hours.
The end user enters the time the affected start time and then the restored end time, I need to ouput the values in hours. Could someone send me a formula to do this?
0
Comment
Question by:cobp
  • 2
2 Comments
 
LVL 19

Expert Comment

by:Montoya
ID: 40305913
are you trying to show the delta between the two dates in hours?
0
 
LVL 19

Accepted Solution

by:
Montoya earned 500 total points
ID: 40305916
Hours = ((End_Date+End_Time)-(Start_Date+Start_Time))*24
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question