Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Time Calculations

  1. #1
    Join Date
    27th August 2004
    Location
    Pensacola, FL
    Posts
    12

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,433

    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)

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    27th August 2004
    Location
    Pensacola, FL
    Posts
    12

    Re: Time Calculations

    Thanks Derk -
    You came through again!

    Robolsson

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Time and cost calculations
    By Alec H in forum EXCEL HELP
    Replies: 2
    Last Post: August 14th, 2006, 22:06
  2. Time Sheet Calculations
    By mpoff in forum EXCEL HELP
    Replies: 7
    Last Post: November 8th, 2005, 09:37
  3. time calculations
    By sekhar in forum EXCEL HELP
    Replies: 13
    Last Post: November 10th, 2004, 19:39
  4. Time calculations
    By mzp in forum EXCEL HELP
    Replies: 4
    Last Post: July 19th, 2004, 20:21
  5. Time Calculations
    By harryaliasjames in forum EXCEL HELP
    Replies: 2
    Last Post: February 7th, 2003, 20:16

Bookmarks

Posting Permissions

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