I have several numbers entered as h:mm and I like to add them and multiply by an hourly rate. for example
A1 6:52 min
A2 5:42 min
A3 6:00 min
I have the column set as time h:mm so when I add all the times it comes out correct but I want to calculate $6.5 per hour times all the hours in column A1:A3 the number does not out correctly I have the following
=sum(A1:A3)*6.50
or
I convert the hours and minuets to minutes total and multiply b .183 which is 6.50 divided by 60
Any help will be appreciated.
thanks
Bookmarks