Number to Time calculation

[serp]

Maybe is stupid, but I can't get it!!

4 Fields:

Begin_time (time)

Num_Hour_per_week (num)

Days (num)

Duration (calc= Num_hours_week / Days)

Now I just need to calculate the END_TIME = (Begin_Time + Duration)

Per exemple; 10:00:00 + 1,5 (duration) should be 11:30:00

[RalphL]

Time is in seconds. Your calculation should be Begin time + 5400.

[serp]

I can't get it.

How can I turn a number to time ??

(in order to "add" this duration to my "Begin_time" )

[RalphL]

Time is a number, the number of seconds since midnight. Filemaker displays this number in a time format.

What did you get? Did you see my correction?

END_TIME = Begin_Time + (Duration * 3600)

[serp]

Perfect!!!

duration = num_hours * 3600 (=seconds per hour)

So Begin_time + duration (calc; time) = end_time

Thanks a lot !!!