hh:mm x $

  • Thread starter Thread starter falco886
  • Start date Start date
F

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
 
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
 
falco886 said:
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
Click to expand...

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,
 
Back
Top