Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2008
    Location
    Naperville, Illinois, United States
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a list that includes a start date/time and a stop date/time. I can create a new colum that calculates the difference. However, the value shows up as either a decimal time (or if I format it as a date/time value, as occuring somewhere around 1900. I have been able to modify the formula to seek the hours of the difference in values, but this is only good up to 23 hours. Is there a way to create a formula that will provide the total duration in hours (or even days, hours, minutes) in sharepoint?

    Thanks!

  2. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,594
    Thanks
    5
    Thanked 1,059 Times in 928 Posts
    Quote Originally Posted by dascooper View Post
    I have a list that includes a start date/time and a stop date/time. I can create a new colum that calculates the difference. However, the value shows up as either a decimal time (or if I format it as a date/time value, as occuring somewhere around 1900. I have been able to modify the formula to seek the hours of the difference in values, but this is only good up to 23 hours. Is there a way to create a formula that will provide the total duration in hours (or even days, hours, minutes) in sharepoint?

    Thanks!
    See if Examples of common formulas - Windows SharePoint Services - Microsoft Office Online helps.

    Joe
    Joe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •