Time x number = ?

[Ben Ball]

I need to calculate time as a number.

i.e I have a time field... which outpute 3 hours. I have a number field which says 45.

I need to calculate 3 x 45 = 135

How can I output a number calc from this to give me the result of 135?

B

[aldipalo]

Your calculation field should contain:

Hour(Time) * Number

/* format as number.

HTH

[comment]

Or:

TimeField * NumberField / 3600

if you want it accurate.

[Ben Ball]

Excellent.. thankyou.