+ Reply to Thread
Results 1 to 4 of 4

Need to find elapsed time between to dates times and then cost according to time elapsed

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    leeds
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need to find elapsed time between to dates times and then cost according to time elapsed

    Hi
    I am trying to run a spread sheet to log alarm call outs (start and end time). Mostly overnight and so can span midnight.
    Once I've captured the elapsed time I need to calculate the charge for the first hour and the charge for the subsequent hour ( or part hour) to give a charge for attending the call out.

    I have used all suggested ways to calculate the elapsed time but without consistency.

    I have tried to attach a sample sheet but don't seem to be able to add one
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Need to find elapsed time between to dates times and then cost according to time elaps

    Are you sure your Start Time is 10:00 PM and End Time is 11:00 AM in the same day???

  3. #3
    Registered User
    Join Date
    01-21-2016
    Location
    Kirksville, MO
    MS-Off Ver
    MS Office 2010
    Posts
    86

    Re: Need to find elapsed time between to dates times and then cost according to time elaps

    Your start time on the second row is after the end time. Are you sure you have the correct dates of 04/30/2018?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: Need to find elapsed time between to dates times and then cost according to time elaps

    Unless you are crossing over midnight twice, maybe you don't need the dates:
    Please Login or Register  to view this content.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate Elapsed Time Between Two Times
    By Kimston in forum Excel General
    Replies: 5
    Last Post: 03-10-2018, 04:35 PM
  2. [SOLVED] How do you calculate elapsed time in hours between times on different dates?
    By RPeruzzi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2013, 01:16 PM
  3. Elapsed time between two dates
    By bmunoz64 in forum Excel General
    Replies: 4
    Last Post: 03-20-2012, 06:00 PM
  4. Using start and end times to determine elapsed time
    By Lothar69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2011, 09:25 AM
  5. Elapsed time with no dates
    By schw1927 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2008, 03:31 PM
  6. calculate elapsed time between dates and times
    By Jenna in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2006, 12:45 PM
  7. Replies: 6
    Last Post: 03-25-2005, 03:06 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1