Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following data as an example:

  1. Time per item: 0.30 min
  2. No.of items: 3

So, what syntax allows me to calculate the correct hours and minutes (hh:mm)?

share|improve this question
For now, your question is quite unclear. You should try to give more details on your problem. – Gnoupi Apr 11 '12 at 13:59

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 :-)

From the link where BoniM says

=A1*B1*24 - this formula does the math correctly without you having to multiply the minutes into a fraction first as long as the cells remain formated as time. Don't change the format to general or if it is general, change it to the time format. (Format, cells, time, choose 37:30:55).

-----------------------------Side notes---------------------

If you have any reason to convert to decimal time this link shows one method simply.


share|improve this answer

You can find help about Excel online, typing in multiply numbers gives multiply numbers.

To do this task, use the * (asterisk) arithmetic operator.

For example, if you type =5*10 in a cell, the cell displays the result, 50.

If you use different cells, you can use their cell names, like so: =A1*A2

For instance, if that would be the equation put into A3. Then A1 = 0.3, A2 = 3, A3 = 9.

Make sure that third column is the format in which you want your data to be...

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .