View Single Post
  #3   Report Post  
Flintstone
 
Posts: n/a
Default


=CEILING((A1+B1)*24,0.01)*C1

You need to format both cells A1 and B1, (FORMAT/CELLS/CUSTOM) to this,
[hh]:mm, type it into box just below the word, Type:

Place 38:46 in cell A1 and 24:22 in B1, place the hourly wage of $8.00
in C1 and paste the formula into cell D1.

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=467287