Also, is it possible to have the total time multiplied by an hourly rate (currency figure)? I've played around with the formula and am unable to work this out.
Does this work for you? Cell H16 has the hourly pay rate and cell G16 is the calculated gross pay. I also changed the formatting in cell G15 to show the total time in just hours and minutes.
You're welcome. You can mark this topic as solved if you have your worksheet working as desired.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!