Calc to to add minutes instead of hours

[Corey-Troy]

I have the following calculation that will add a number field hours to a date field, but i cannot work out the solution to modify it to add minutes to the time field instead of hours.

MonJ1Start - Date Field

MonJ1Site - Number Field

Time(Mod(Hour(MonJ1Start) + MonJ1Site;24); Minute(MonJ1Start); Seconds(MonJ1Start))

How can i do this?

Edited October 28, 2010 by Guest

[comment]

add a number field hours to a date field

This makes no sense: you cannot add hours to a date field.

add minutes to the time field

What time field?

[Corey-Troy]

Solved by self:

Time(Hour(MonJ1Start); Mod(Minute(MonJ1Start) + MonJ1Site;1440); Seconds(MonJ1Start))

I moved the 

Mod(

from the Hour to the Minute, and now it is ading the field number value to the time field in minutes.

Sorry i think i think i stated Date instead of Time for one field type.

Edited October 28, 2010 by Guest

[comment]

:idunno:

If all you want is to add a number of minutes to a time field, then =

Timefield + 60 * Numberfield

should be sufficient.