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?

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

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?