hh:mm x $

[falco886]

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

 

[Medemper]

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.
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

 

[Beto]

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,

 

[falco886]

thank you very much. multiplying by 24 helped