T
Teri
Thanks to Biff for helping me get the first of my timesheet problems figured
out. Now I am hoping to be able to take the amount of hours and multiply it
by a dollar amount to get a total.
So I want to take 25:30 (column a) and multiply that by $5 hour (column c)
to get a grand total.
So I put in: =a28*c28 and it gives me $3.92 which is obviously not right.
Column a is formatted as [h:mm] and column c is formatted as currency which
I think is where my problem is but don't know what I need to do to fix it.
Thanks for any insight.
out. Now I am hoping to be able to take the amount of hours and multiply it
by a dollar amount to get a total.
So I want to take 25:30 (column a) and multiply that by $5 hour (column c)
to get a grand total.
So I put in: =a28*c28 and it gives me $3.92 which is obviously not right.
Column a is formatted as [h:mm] and column c is formatted as currency which
I think is where my problem is but don't know what I need to do to fix it.
Thanks for any insight.