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

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/

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.

hh:mm x $
 

thank you very much. multiplying by 24 helped


---
Message posted from http://www.ExcelForum.com/