RE: Tracking Time (Hours/Mins)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Peo Sjoblom (PeoSjoblom_at_discussions.microsoft.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 08:39:08 -0800

If the rate is for hours use

=(End-Start)*24*payrate

if it is pay per minute

=(End-Start)*1440*payrate

format as curremyc, number or general or else you'll get the amount in time
format which can look funny

Regards,

Peo Sjoblom

"sdmccabe" wrote:

> I would appreciate a suggested formula for tracking time, actually duration,
> subtracting the time in one posted column from another. The elapsed time
> will be within a twenty four hour period, so the date/time format need not
> include one day to another, if that matters. The result will be used to
> produce a dollar amount, so the unit result should probably be minutes, as
> opposed to a decimal – right? Is this possible?

Relevant Pages

  • Re: Need help building a simple worksheet, please
    ... Extra Owed Amount % of Debt Amount to Pay Them ... Copy that formula down for Jim, Bill, etc. Format the entire column as ... good way to pay back credit cards. ...
    (microsoft.public.excel)
  • RE: File Merge Help
    ... It depends whether you want to change the underlying value stored in the ... SET Amount = Amount/100; ... So what should i do in access to format cell and devide by 100. ... "Ken Sheridan" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: How to merge monetary values from Excel to Word?
    ... DSmithWBP wrote: ... "Dave Peterson" wrote: ... In the example below a field named Amount is formatted for currency. ... a way to set this up in Excel so it will merge in true format? ...
    (microsoft.public.excel.misc)
  • RE: Formatting output text as currency
    ... you would not be able to assign the results of the Format() ... function, a string, to a Double variable. ... It takes the Check Amount field and makes sure it is a currency value. ... an implicit conversion of the currency amount to a Double. ...
    (microsoft.public.access.formscoding)
  • Re: Excel - Match positive and negative numbers
    ... This can partially be overcome by changing the '>0' in both formulae to '=1' and setting up a second conditional format based on the same formula, but with '>1' and a different colour to highlight any many-to-one matches. ... two debits of the same amount, where there is only one credit of the same amount ...
    (microsoft.public.excel.programming)