| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I automatically calculate dollars earned with time work
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I automatically calculate dollars earned with time work
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total Time Worked - How to Calculate | Excel Worksheet Functions | |||
| How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
| converting time worked to dollars earned. | New Users to Excel | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| Calculate time worked | Excel Programming | |||
Linear Mode
