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.
Bookmarks