Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Calculate Time difference between two Dates

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calculate Time difference between two Dates

    Hi Ozgrid Community

    Iím stuck on this (probably simple calculation) I have two Rows of data.
    Each row contains a unique Name column and separate columns for Date, Hour and Minute.

    I would like to calculate the Time difference in Days, Hours and Minutes between the two Dates.

    Iím not sure if the way Iíve set it up is the most practical.

    Iíll attach the spreadsheet to better explain. If anyone could assist that would be great

    Thanks so much!
    Attached Files

  • #2
    Re: Calculate Time difference between two Dates

    I wouldn't do it that way, but that is just my preference, I would set it up as a timestamp, date and time, and manage those.

    However, you should at least cater for the sum of minutes exceeding 60, and hours exceeding 24, and adjust the other values accordingly.
    HTH

    Bob

    Comment


    • #3
      Re: Calculate Time difference between two Dates

      I have messed about with the formulas you had in your spreadsheet, using the TIME function to do all the base 60/base 24 stuff for you.
      Attached Files
      --
      I'm not getting you down am I?

      Comment


      • #4
        Re: Calculate Time difference between two Dates

        Thanks Guys so much. It worked. Thanks

        Comment


        • #5
          Re: Calculate Time difference between two Dates

          See Also Date & Times in Excel for a better understanding of them.

          Comment

          Trending

          Collapse

          There are no results that meet this criteria.

          Working...
          X