Sep 16 2021 10:09 AM
Sep 16 2021 10:37 AM
@MsCherie Suppose the standard rate is in A1 and the hours are in column B1 and down, you could use in C1:
and copy it down if needed.
Sep 16 2021 11:20 AM
I tried this and I'm going to see if I can drop it to you so you can see how it looks it should be $2,081.25 so I am doing something wrong.
Sep 16 2021 11:54 AM - edited Sep 16 2021 11:57 AM
@MsCherie You need to multiply the duration (83:15) by 24 to get the numerical value of hours, i.e. 83.25. multiply by 25 ( the hourly rate) and you'll get 2081.25. Make sure you format H27 as "General".