### Title

Time Card Calculation

### Post

Hello, I am having a problem with a simple time card calculation. I would like to use a start time, end time and time for lunch. I would like to just put in minutes for lunch such as 30 or .5(for half an hour)

Currently I have the folowing fields:

WorkHours Start- Time Field

Work Hours End- Time Field

Work Hours Lunch- Time Field

Work Hours Daily Total- Time Field Caculation

I tried several different way and types of fields but the caculations never seems to work.

Time fields are number fields that record time since midnight in seconds.

Make Work Hours Lunch a number field.

Then the following two calculation options will compute your total time worked:

WorkHours End - WorkHours Start - WorkHours Lunch * 60 //if Lunch time is entered in minutes (such as 30)

WorkHours End - WorkHours Start - WorkHours Lunch * 3600 //if Lunch time is entered in hours (Such as 0.5)

You can select time as the return type to show time worked in hours and minutes or you can divide the result by 3600 and select number as the return type to compute the time worked in Hours.