Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 2 down vote favorite

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
2  
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 Everett 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

closed as too localized by ChrisF♦ Feb 9 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, see the FAQ.

Browse other questions tagged or ask your own question.