Results 1 to 9 of 9

Excel Find Starting and finishing Time

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2012
    Location
    Lisboa, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    24

    Excel Find Starting and finishing Time

    Hello there

    I'm having trouble find the right idea for a new project i have and i was wondering if the following is possible. you see i have the fallowing table...


    TASK Starting Time Finishing Time TEST
    Agendamentos Recolhas 11:15 11:26
    Agendamentos Recolhas 11:31 11:40 BREAK
    Reagendamentos 11:41 11:45
    Reagendamentos 11:46 11:49
    Reagendamentos 11:50 11:54 BREAK
    Agendamentos Recolhas 15:03 15:12
    Agendamentos Recolhas 15:13 15:21
    Agendamentos Recolhas 15:22 15:34 BREAK
    Confirmacoes Comerciais 16:07 16:08
    Confirmacoes Comerciais 16:20 16:41 BREAK
    Agendamentos Recolhas 19:00 19:10
    Agendamentos Recolhas 19:36 19:46
    Agendamentos Recolhas 19:47 20:02 BREAK



    There are different task that one person performes througth the day and in most of the cases they are done in alternative ways and not straight foward.

    My question is... is it possible that every time that the word "BREAK" appears it counts the first starting and the last finishing time together in a new column? the point is to know when i started and stopped that task.

    Am i making sense? sorry for the bad english and for the table... for some reason i canīt add attachs or images...

    Thanks in advance
    Last edited by Iceman1988; 07-14-2012 at 06:31 AM.

Thread Information

Users Browsing this Thread

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

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