How do I automatically calculate dollars earned with time worked?

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.

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.

Thannk you. I see where the o.225 comes from but where did the 7.5 come in?
I'd like to understand this, not just apply it.


"Gary''s Student" wrote:

> 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.

The 7.5 is the hourly rate ($7.50) as in your original post.


Brian Jacobson wrote:
> Thannk you. I see where the o.225 comes from but where did the 7.5 come in?
> I'd like to understand this, not just apply it.
>
>
> "Gary''s Student" wrote:
>
> > 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.