Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

calculating in FileMaker

calculating in FileMaker

calculating in FileMaker

I need to move into FileMaker for a specific project (most of my work has been in Excel).  

In FileMaker 7 I have a sign in field and a sign out field.  A third field subtracts one from the other giving me the hours worked in the 1:30 format (one hour and a half.) The next field holds the hourly rate of pay.  I need to be able to multiply the amount of time worked by the hourly rate.  Can anyone help?  Thanks in advance.

RE: calculating in FileMaker

Several ways to go.
If you-re sure the start time and the end time will always be the same day:
((timeStart - timeStop)/3600)*hourRate

Better is to use the power in FM for date and time, which will cover the possibility that the end time will not be on the same day as the start time.
For this we use the TimeStamp function.

Your calculation can be something along these lines:
Let ([
hourStart = GetAsTimestamp ( timeStart );
hourStop = GetAsTimestamp ( timeStop ) ;
diff = GetAsNumber ( hourStop - hourStart );
diffHour = diff/3600];
hourRate * diffHour )

where the timeStart and timeStop fields are type: Timestamp.

I show the formula in its longest form so you can understand what happen within the formula.
There is a way to make it shorter.


RE: calculating in FileMaker


The the first solution will work, as start and stop times are all between 8 and 6 on the same day.

I appreciate your help.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close