L
Ltat42a
Hi...maybe you can help.
I made a spreadsheet to track monies spent on overtime. I have over 20
people that I'm tracking for. I have their name, number of hours, their
hire date, and their hourly rate.
I need help with two items -
1. I have a section of the spreadsheet that summarizes everyone's name
and the entire amount spent on OT. I'm using the formula =B2 to copy
their name from cell B2 to L121. If there is no name listed in B2, L121
returns a value of 0. How can I show L121 as blank instead of 0? If a
name is listed in B2, then it will appear in L121.
2. I'm using a date calculation to tell me how long they have been
employed -
=DATEDIF(A7,TODAY(),"m")/12.
This gives me their time in service on the job. It gives me the
calculation in a 2 decimal format. I need it in a whole number. When I
change the format to a whole number, Excel rounds the number up if the
value is more than .50 (i.e. 20.75 is rounded up to 21). How can I keep
Excel from rounding the number up?
20.75 years should read as 20 years instead of 21 years.
Any suggestions?
Thanx in advance......Ltat42a
I made a spreadsheet to track monies spent on overtime. I have over 20
people that I'm tracking for. I have their name, number of hours, their
hire date, and their hourly rate.
I need help with two items -
1. I have a section of the spreadsheet that summarizes everyone's name
and the entire amount spent on OT. I'm using the formula =B2 to copy
their name from cell B2 to L121. If there is no name listed in B2, L121
returns a value of 0. How can I show L121 as blank instead of 0? If a
name is listed in B2, then it will appear in L121.
2. I'm using a date calculation to tell me how long they have been
employed -
=DATEDIF(A7,TODAY(),"m")/12.
This gives me their time in service on the job. It gives me the
calculation in a 2 decimal format. I need it in a whole number. When I
change the format to a whole number, Excel rounds the number up if the
value is more than .50 (i.e. 20.75 is rounded up to 21). How can I keep
Excel from rounding the number up?
20.75 years should read as 20 years instead of 21 years.
Any suggestions?
Thanx in advance......Ltat42a