Forum Discussion

RoxanneZiegler's avatar
RoxanneZiegler
Qrew Cadet
8 years ago

Calculation for Time In and Time Out form

I have 3 fields

Time In ( time field)

Time Out ( time field)

Total Time (Duration field)

I want it to convert to amount of time spent at work

Time In 10am Time out 2 pm = total time of 4 hours

I put this in and it tells me -8.00

My formula is ([Time Out]-[Time In])

I have tried turning this around and or adding Sum before the formula - nothing is working to give me an answer of 4hrs

Ask about Quickbase functionality
Formulas and functions
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    This seems rather odd.  Its hard to say what might be causing this.

    Can you share some screen shots of the fields and formula.  I really don't know, but maybe we'll see something...
  • MichelleMichell's avatar
    MichelleMichell
    Qrew Cadet
    8 years ago
    Are you sure you entered AM for Time In and PM for Time Out? If it's getting -8.00, then it could be that they are entered either both AM or both PM.
  • AnnaTamaoka's avatar
    AnnaTamaoka
    Qrew Member
    8 years ago
    Just confirming that these are Date/Time fields and not just Time fields (I assume they are because I don't think there is a "Time" type option). I have a similar table where users enter a start date/time and an end date/time and it calculates duration, but you have to specify the date:

    Result:


    Setup:


    Duration formula:
    [End Time (Date / Time)]-[Start Time (Date / Time)]

    Fields (both Start and End time fields are set up the same way)

  • PaulVorster1's avatar
    PaulVorster1
    Qrew Cadet
    7 years ago
    Thank you for the assistance, just another question? Have you done this formula for weekdays?