View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DubboPete DubboPete is offline
external usenet poster
 
Posts: 30
Default Turning a time value into a numeric value

Hello all,

I have a calculated time value which records the time I spend on
database work for a client. it shows the hours worked in the cell as
"6:45" (6 hours and 45 minutes database work).

CELL A CELL B CELL C
START FINISH TIME WORKED

12:30 19:15 6:45

I'd like to be able to calculate in another cell, say Cell D, the
value of 6hrs 45mins at $nn.nn per hour, so if I got paid $10 per
hour, the calculated cell would reflect $67.50...

Would someone please help with the formula?

thanks in anticipation

DubboPete