Hourly Sales Formula

[m_789]

Hi all,

can anyone help me work out how many sales per a hour my team are doing?

the sales per hour figure needs to appear in Q3

K3 = how many sales they done
C3 = how many hours they have worked in the HH:MM:SS format

K3 = 3 (total sales done)
C3 = 07:30:00 (total hours worked)
03 = display the amount of sales per hour

appreciate your help guys

[etaf]

you need to change the time to decimal use
=INT(C3)*24+HOUR(C3)+ROUND(MINUTE(C3)/60,2)

SO
K3 / (INT(C3)*24+HOUR(C3)+ROUND(MINUTE(C3)/60,2))

[m_789]

you need to change the time to decimal use
=INT(C3)*24+HOUR(C3)+ROUND(MINUTE(C3)/60,2)

SO
K3 / (INT(C3)*24+HOUR(C3)+ROUND(MINUTE(C3)/60,2))

thanks for this mate works and does the job really appreciate this :-)

how do i stop the 2nd one from erroring?

=K3/(INT(C3)*24+HOUR(C3)+ROUND(MINUTE(C3)/60,2))[/QUOTE]

[etaf]

whats the error ?

#Value - if you have formulas in the cell C3 and not a time ?
#DIV/0! if you have zero or blank for the K3 and no time

=IFERROR(K3/(INT(C3)*24+HOUR(C3)+ROUND(MINUTE(C3)/60,2)),"") will show a blank for those errors
The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.