View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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