Web Applications Stack Exchange is a question and answer site for power users of web applications. 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'm trying to use Google Spreeadsheets as a time report tool where I insert the number of hours worked on a project, the cost per hour & the total cost for this post. My sheet looks like this:

Time    Price/hour    Price
 1         10          10
0.45       10          7.5

But I cannot for my life understand how I'll do to to calculate the price correct. Any ideas?

share|improve this question

closed as too localized by ChrisF Feb 9 '13 at 21:38

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

You either store all the time entries in minutes and then divide the price by 60, or store it as fractions and then 45 minutes becomes 0.75. Otherwise you’d have to make a function that computes the price for subdivisions of an hour differently (divide the price/hour by 60 and then multiply the price by 100). – Alex Aug 30 '12 at 10:21
Or maybe there is a Spreadsheets function that does this, but I’m not aware of it. – Alex Aug 30 '12 at 10:23
Every electronic time reporting system I've ever seen requires you to convert time to decimal, and usually in now less than quarter-hour increments. So 45 minutes would have to be recorded as 0.75. – Al E. Aug 30 '12 at 12:59
Thanks a lot. I solved it by doing two columns. One for hours & one for minutes. I think that'll be most clear for my customer. Again. Thanks :) – Ola Lindberg Sep 1 '12 at 7:27