Announcement

Collapse
No announcement yet.

Time Calculations

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

  • Time Calculations

    Thanks for helping!

    I need to calculate the following:

    Cell A is a start time, example 18:00 (6 pm)

    Cell B is a stop time, example 01:00 (1 am)

    How would I write a calculation that would reflect the 7 hours that this job ran?

    Thanks -

    Robolsson

  • #2
    Re: Time Calculations

    The secret to working with times is that Excel counts time in units of days. For your problem, assuming the elapsed time is less than 24 hours, use the formula
    =IF(A1>B1,1+B1-A1,B1-A1)*24
    which will give you the number of hours (with fractions of an hour if needed)
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

    Comment


    • #3
      Re: Time Calculations

      Thanks Derk -
      You came through again!

      Robolsson

      Comment

      Working...
      X