Calculation combining number and time

[KateJ]

I'm new! Thanks for any help anyone can provide on my problem (hopefully not everyone is at DevCon!!)

I have a calculation that involves both a number and a period of time. It's more or less this:

Miles (number field) / miles per hour (number field) + time (time field)

I need the result to be in time format.

For example:

2500 miles / 500 miles per hour + 00:15 (15 minutes) = 5:15:00

I've been fooling around with TextToTime, etc. and not getting any where.

Again, any help would be appreciated.

[-Queue-]

Time( Miles / MPH, Minute(time), 0 )

if your time may have hours,

Time( (Miles / MPH) + Hour(time), Minute(time), 0 )

[KateJ]

Phew!

Thanks, Queue.