Thread: Time (clock) times a number= very high number?

I have time start and time end and the difference between the two times. In a third column I have profit and want to calculate the profit per hour.
When I divide the profit with the time spent I get a very very high number.

If I for instance type in 1 hour of work and profit 100, then I get profit per hour 2400. (profit/hours spent)

On a side note I am trying to get the numbers as 24 hours and not use am or pm and in the spread sheet I get these numbers but in the box at the top where you see the formulas etc. it shows as am and pm.

I have uploaded an example.

Change your formula in C4 to: =(B4-A4)*24

and format as General or Number.

In Excel, date and time is converted to a number, and an hour is recorded as a fraction of a 24 hour day, or 0.042, so when you divide your profit of "100" you get 2400.

HTH