Closed Thread
Results 1 to 6 of 6

Calculation time

  1. 11-07-2017, 07:59 AM #1
    Pippo83
    Pippo83 is offline
    Registered User
    Join Date
    11-07-2017
    Location
    potenza
    MS-Off Ver
    excel 2013
    Posts
    12

    Calculation time

    Hello,
    I have a problem, I do not know how to get last column .
    Help me, please.



    0013024054 0:00:00 0:20:45 0:20:45
    0013024054 0:00:00 0:20:45 0:20:45
    0013024054 0:00:00 0:20:45 0:20:45
    0013024056 0:00:00 0:31:22 0:21:42
    0013024056 0:00:00 0:31:22 0:21:42
    0013024056 0:09:40 0:31:22 0:21:42
    0013024056 0:00:00 0:31:22 0:21:42
    0013024056 0:00:00 0:31:22 0:21:42
    0013024056 0:00:00 0:31:22 0:21:42


    Thanks a lot
    Last edited by Pippo83; 11-07-2017 at 08:10 AM.
    Reply With QuoteRegister To Reply
  2. 11-07-2017, 08:17 AM #2
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Calculation time

    By last column, do you mean 0:20:45?

    If yes, try the below:

    =--TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))

    See the attached file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-07-2017, 09:28 AM #3
    Pippo83
    Pippo83 is offline
    Registered User
    Join Date
    11-07-2017
    Location
    potenza
    MS-Off Ver
    excel 2013
    Posts
    12

    Re: Calculation time

    Thanks a lot
    Sorry, I did not explain well, I attached the file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-07-2017, 09:54 AM #4
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Calculation time

    Duplicate thread.

    Original here:
    https://www.excelforum.com/excel-for...lculation.html
    Reply With QuoteRegister To Reply
  5. 11-07-2017, 10:09 AM #5
    Pippo83
    Pippo83 is offline
    Registered User
    Join Date
    11-07-2017
    Location
    potenza
    MS-Off Ver
    excel 2013
    Posts
    12

    Re: Calculation time

    I do not know how to cancel duplicate.
    Reply With QuoteRegister To Reply
  6. 11-07-2017, 10:31 AM #6
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Calculation time

    Use Report Post and ask moderator to close one of two threads
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Start time and End time Calculation sheet and uneditable of Time
    By tgray007 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-17-2017, 10:02 AM
  2. Date and time calculation excluding breaks, weekends for a time period
    By Pubhub in forum Excel General
    Replies: 2
    Last Post: 02-03-2017, 07:39 AM
  3. Budgeting out percentages of time from a time card calculation sheet
    By mhadaway in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2015, 05:05 PM
  4. [SOLVED] Excel calculation for adding time and calculating remaining time
    By mark888 in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 01-12-2015, 12:55 PM
  5. [SOLVED] Excel calculation for adding time and calculating remaining time
    By mark888 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2015, 06:38 AM
  6. [SOLVED] Time entry on UserForm displaying inccorectly and calculation not working on the time.
    By Colin Smit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-12-2014, 01:21 PM
  7. Payroll time sheet calculation where time exceeds 24 hours
    By Rolo1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2014, 08:57 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1