| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i calculat time(hh:mm)*(number)...(09:00)*100 $
I want to make a Timesheet and calculate the some of time working with
(hh:mm) cell s format *number(time payment) .For Example: (09:00)*(100)$. Can Anybody help me,pls? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i calculat time(hh:mm)*(number)...(09:00)*100 $
If A1 holds 9:00:00 (9 hours), you could use:
=a1*100*24 You may want to read about how excel stores times (and dates): http://cpearson.com/excel/datetime.htm amir wrote: I want to make a Timesheet and calculate the some of time working with (hh:mm) cell s format *number(time payment) .For Example: (09:00)*(100)$. Can Anybody help me,pls? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i calculat time(hh:mm)*(number)...(09:00)*100 $
Mutliply your time (09:00) by 24 to get hours, then multiply by your rate to get pay.
HTH, Bernie MS Excel MVP "amir" wrote in message ... I want to make a Timesheet and calculate the some of time working with (hh:mm) cell s format *number(time payment) .For Example: (09:00)*(100)$. Can Anybody help me,pls? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculat an expiration date | Excel Worksheet Functions | |||
| 2007 Update links does not send message when workbook not calculat | Excel Discussion (Misc queries) | |||
| How do I change the currency on the invoice template that calculat | Excel Discussion (Misc queries) | |||
| Calculat years married or age of someone on today's date | Excel Worksheet Functions | |||
| Is military time available in Excel? If so, how would I calculat. | Excel Worksheet Functions | |||
Linear Mode
