Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    3

    Unanswered: Calculated Fields

    Hiya

    I have these fields on my table "Jobs"

    ArriveTime (Combo)
    DepartTime (Combo)
    BreakStart (Combo)
    BreakEnd (Combo)

    TotalTime

    I need to add the Arrive & Depart Time - BreakTimes

    So if they start work @ 8am
    Finish work @@ 4pm

    And start Lunch @ 12pm
    End lunch : 12:30pm

    This would be - 7.5 Hours

    Cheers

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    so what have you tried so far?

  3. #3
    Join Date
    Jul 2011
    Posts
    3
    to be honest, not very much

    I have googled it, and all I can really find is calculating Age and Dates but not so much time

  4. #4
    Join Date
    Jul 2011
    Location
    India
    Posts
    13
    Hi,

    MySQL :: Re: How to calculate time difference

    hope it help

    all the best

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •