Hrs (text) in work variance

N

nat

Hi,

I want to copy the information from the work variance
field into a number field and it does not let me because
of the Hrs tagged after the number. How can I resolve
this?
I've tried using a text field but, a text field does not
give me the sum at the summary level (cannot select to Sum
in Customize Fields).

Help!

Thanks!

Nat
 
W

Willy_comp

Nat,

This will do the trick. Just remove the characters at the back (in example
formula - 4 as the " hrs" are added).

Create a number field formula
left([Work Variance];len([Work Variance]-4))/60

and then set "sum" as roll up. (divide by 60 to change minutes into hours)

regards,
Willy
 
Top