I have the following data as an example:
 Time per item:
0.30 min
 No.of items:
3
So, what syntax allows me to calculate the correct hours and minutes (hh:mm)?
I have the following data as an example:
So, what syntax allows me to calculate the correct hours and minutes (hh:mm)? 


To calculate the time properly in excel is to make sure that the cell used is formated as "time" then the program will recognise it as time, and get all the numbers correct for calculating time. Until such time we switch to the metric time system with 100 time units in each longer time unit :) http://www.excelbanter.com/showthread.php?t=136187 From the link where BoniM says
Side notes If you have any reason to convert to decimal time this link shows one method simply. =INT(A2)*24+HOUR(A2)+ROUND(MINUTE(A2)/60,2) 


You can find help about Excel online, typing in
If you use different cells, you can use their cell names, like so: For instance, if that would be the equation put into A3. Then Make sure that third column is the format in which you want your data to be... 

