Re: converting duration into currency



On Tue, Jul 06, 2004 at 03:01:14PM -0700, Eric Allen wrote:
I have a spreadsheet in which I'd like to convert a time duration into a 
dollar amount for hourly wages. When I try to just reference the 
duration and format it as a "currency" cell, I get weird values. How do 
I get 25 minutes = 25 dollars?

Times are stored as day fractions.
To convert time -> money

=Time*24*currency_per_hour



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]