View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How do I automatically calculate dollars earned with time worked?

5:25 is really 0.225694444 since time is really a fraction of a 24 hour day.

If 5:25 is in A1 then =A1*7.5*24 should give you want you want.
--
Gary's Student


"Brian Jacobson" wrote:

I calculate hours worked by subtracting Stop time from Start time givng me
hours, minutes worked. For example, hours worked 5:25. I use this to
multiply by a fixed dollar amount like $7.50. The product is not correct.
What am I doing wrong? Using Excel Office 2003.