remove the "hrs" from work field not the number

[jts]

remove the "hrs" from work field not the number in new column

 

[JulieS]

Hi jts,

I'm not sure precisely what you are asking for. You can insert a custom
number field (i.e. Number1) and then customize the field, setting the
formula to [Work]/60 to get just the number of hours without the "hrs".

I hope this helps. Let us know how you get along.

Julie

 

[Redneck David]

Julie,

Thank you for your post.

Can you tell me why dividing 60 removes the hours. I don't get it.

David

Hi jts,

I'm not sure precisely what you are asking for. You can insert a custom
number field (i.e. Number1) and then customize the field, setting the
formula to [Work]/60 to get just the number of hours without the "hrs".

I hope this helps. Let us know how you get along.

Julie

remove the "hrs" from work field not the number in new column

 

[John M.]

The division by 60 is needed because the work field is stored in minutes.
The "hrs" are not displayed because it is a custom number field.

John M.

Julie,

Thank you for your post.

Can you tell me why dividing 60 removes the hours. I don't get it.

David

Hi jts,

I'm not sure precisely what you are asking for. You can insert a custom
number field (i.e. Number1) and then customize the field, setting the
formula to [Work]/60 to get just the number of hours without the "hrs".

I hope this helps. Let us know how you get along.

Julie

remove the "hrs" from work field not the number in new column

 

[JulieS]

Hi David,

You are welcome and I see that John M. has answered the question. Thank
you John M.

Julie

Julie,

Thank you for your post.

Can you tell me why dividing 60 removes the hours. I don't get it.

David

Hi jts,

I'm not sure precisely what you are asking for. You can insert a
custom
number field (i.e. Number1) and then customize the field, setting the
formula to [Work]/60 to get just the number of hours without the
"hrs".

I hope this helps. Let us know how you get along.

Julie

remove the "hrs" from work field not the number in new column