+ Reply to Thread
Results 1 to 2 of 2

calculate time start and finish times and deducts breaks

  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    Southampton
    MS-Off Ver
    Excel 2007
    Posts
    1

    calculate time start and finish times and deducts breaks

    Hi all this might seem like a long shot but what I want. I have got my work time sheet which I fill in daily as i am a lorry driver. but I would like is to be able to fill this in on my phone daily and it calculate my work time for me.

    So if I put in my start time and FINISH time it calculates my total duty plus after I have input my break time and POA Time it add these two up and deducts this from my total duty and in puts it in to the working time.

    Can any one help I hope this make sense.
    Attached Files Attached Files
    Last edited by jasonjkd; 06-22-2010 at 05:45 AM.

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: calculate time start and finish times and deducts breakes

    Try
    I5=D5-C5
    J5=I5-(F5+G5)

    You didn't specify driving time...
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

+ Reply to Thread

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