+ Reply to Thread
Results 1 to 5 of 5

Calculate running time based on date and time between previous entry

  1. #1
    Registered User
    Join Date
    03-28-2016
    Location
    Coventry
    MS-Off Ver
    Microsoft 365
    Posts
    65

    Calculate running time based on date and time between previous entry

    Hi, all..

    This ones had me I'm afraid. I have attached a test book but what I am looking for is an auto calculation of completed hours based on a date and time entry. I need the result in hours only.

    Column A is the date entry
    Column B is the Time entry
    Column C I need a formula to calculate the completed hours based on the previous completed hours plus the hours completed from the next entry if that makes any sense.

    As always, thanks for all the help on here.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Calculate running time based on date and time between previous entry

    Hi in C3 and pulled down try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-28-2016
    Location
    Coventry
    MS-Off Ver
    Microsoft 365
    Posts
    65

    Re: Calculate running time based on date and time between previous entry

    Hi, Many thanks for this... It does kinda work but it doenst include the running time from the day before. so if the first day was 24 hrs and then the second result is 24 hours it needs to read 48 hours. Your formula is 3/4 of the way there just needs to continually add the hours too.

  4. #4
    Registered User
    Join Date
    03-28-2016
    Location
    Coventry
    MS-Off Ver
    Microsoft 365
    Posts
    65

    Re: Calculate running time based on date and time between previous entry

    Don't worry, I've managed to add that bit! thankyou very much

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Calculate running time based on date and time between previous entry

    Quote Originally Posted by MTC2016 View Post
    Hi, Many thanks for this... It does kinda work but it doenst include the running time from the day before. so if the first day was 24 hrs and then the second result is 24 hours it needs to read 48 hours. Your formula is 3/4 of the way there just needs to continually add the hours too.
    I don't know where you get that idea. see attached in col D. It returns EXACTLY what you entered
    Attached Files Attached Files

+ 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. Need Help - The time entry is happening continuously - need to calculate only valid Time
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2018, 09:50 PM
  2. [SOLVED] Calculating a previous work shift time (05:30, or 17:30) based on current time
    By andrew.why in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2017, 09:09 PM
  3. Replies: 1
    Last Post: 06-14-2016, 10:25 AM
  4. [SOLVED] Calculate time remaining based on end date & time and current date
    By Kaz09 in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 08-19-2014, 07:11 AM
  5. Replies: 8
    Last Post: 01-10-2014, 03:43 AM
  6. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  7. Identify the entry which's date & time is intersecting another entries date & time
    By girish.talele in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2012, 07:35 AM

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