Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hh:mm x $
i am trying to make a time sheet were i need to multiply total hours b
a dollar amount. can't seem to get it running.what i need is th formula and what format to use. converting hours and minutes to an other format messes things u -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hh:mm x $
If 4:00 (in time format) is in a1, then in a2 you could put hour(a1) to get 4 (make sure its general or number format).
Might help get you started. "falco886 " wrote in message ... i am trying to make a time sheet were i need to multiply total hours by a dollar amount. can't seem to get it running.what i need is the formula and what format to use. converting hours and minutes to any other format messes things up --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hh:mm x $
falco886 < wrote:
i am trying to make a time sheet were i need to multiply total hours by a dollar amount. can't seem to get it running.what i need is the formula and what format to use. converting hours and minutes to any other format messes things up Just multiply the result by 24 and set the format of the cell to number. Ex: A1 - 10:30 (In Excel time format) A2 - 100 (dollars per hour) A3 - 1,050 (=A1*A2*24 Formatted as number) Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
hh:mm x $
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|